DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 1907: from per_people_extra_info

1903: cp_pre_org_id number) is
1904: select pei_information5,
1905: pei_information6,
1906: pei_information7
1907: from per_people_extra_info
1908: where person_id = cp_person_id
1909: and pei_information6 = to_char(cp_pre_org_id)
1910: and pei_information_category = 'PAY_CA_RL2_FORM_NO';
1911:

Line 2061: from per_people_extra_info

2057: cp_pre_org_id varchar2) IS
2058: select pei_information2,
2059: pei_information3,
2060: pei_information4
2061: from per_people_extra_info
2062: where person_id = cp_person_id
2063: and pei_information1 = cp_pre_org_id
2064: and pei_information_category = 'PAY_CA_RL2_INFORMATION';
2065: