DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 3781: from per_people_extra_info target

3777:
3778: CURSOR c_get_1099_distribution_info(cp_person_id in number,
3779: cp_tax_unit_id in number) IS
3780: select pei_information2
3781: from per_people_extra_info target
3782: where person_id = cp_person_id
3783: and target.pei_information1 = cp_tax_unit_id
3784: and information_type= 'PAY_US_PENSION_REPORTING';
3785:

Line 3791: from per_people_extra_info target

3787: --
3788: CURSOR c_get_first_yr_roth_contrib(cp_person_id in number,
3789: cp_tax_unit_id in number) IS
3790: select pei_information3
3791: from per_people_extra_info target
3792: where person_id = cp_person_id
3793: and target.pei_information1 = cp_tax_unit_id
3794: and information_type= 'PAY_US_PENSION_REPORTING';
3795: