All standars package footprints are avialable in installed directory only...
If they are not enough , you need to prepare them...
most of the pad stacks also available there...you can use them for your footprints...if they are not enogh for your design..you need to modify available pads...
footprints available in...Cadence\SPB_16.3\share\pcb\pcb_lib\symbols...
you can find pads also in that folder...