DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 2612: from per_people_extra_info

2608: cp_pre_org_id number) is
2609: select pei_information5,
2610: pei_information6,
2611: pei_information7
2612: from per_people_extra_info
2613: where person_id = cp_person_id
2614: and pei_information6 = to_char(cp_pre_org_id)
2615: and pei_information_category = 'PAY_CA_RL2_FORM_NO'
2616: order by pei_information7; -- bug 14701748

Line 2767: from per_people_extra_info

2763: cp_pre_org_id varchar2) IS
2764: select pei_information2,
2765: pei_information3,
2766: pei_information4
2767: from per_people_extra_info
2768: where person_id = cp_person_id
2769: and pei_information1 = cp_pre_org_id
2770: and pei_information_category = 'PAY_CA_RL2_INFORMATION';
2771: