DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 3170: from per_people_extra_info

3166: cp_pre_org_id number) IS
3167: select pei_information5,
3168: pei_information6,
3169: pei_information7
3170: from per_people_extra_info
3171: where person_id = cp_person_id
3172: and pei_information6 = to_char(cp_pre_org_id)
3173: and pei_information_category = 'PAY_CA_RL1_FORM_NO'
3174: order by pei_information7; /* Bug 13564765 sbachu*/