DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 3194: from per_people_extra_info target

3190:
3191: CURSOR c_get_1099_distribution_info(cp_person_id in number,
3192: cp_tax_unit_id in number) IS
3193: select pei_information2
3194: from per_people_extra_info target
3195: where person_id = cp_person_id
3196: and target.pei_information1 = cp_tax_unit_id
3197: and information_type= 'PAY_US_PENSION_REPORTING';
3198:

Line 3204: from per_people_extra_info target

3200: --
3201: CURSOR c_get_first_yr_roth_contrib(cp_person_id in number,
3202: cp_tax_unit_id in number) IS
3203: select pei_information3
3204: from per_people_extra_info target
3205: where person_id = cp_person_id
3206: and target.pei_information1 = cp_tax_unit_id
3207: and information_type= 'PAY_US_PENSION_REPORTING';
3208: