DBA Data[Home] [Help]

APPS.PAY_CA_RL1_AMEND_MAG dependencies on PER_PEOPLE_EXTRA_INFO

Line 1454: FROM per_people_extra_info pei

1450: WHERE ppa.payroll_action_id = p_payroll_action_id;
1451:
1452: CURSOR c_original_slipno (p_person IN NUMBER,p_tax_year IN VARCHAR2,p_trans_id IN NUMBER) IS
1453: SELECT pei_information7
1454: FROM per_people_extra_info pei
1455: WHERE pei_information6=to_char(p_trans_id)
1456: AND substr(pei_information5,1,4)=p_tax_year
1457: AND to_number(pei.person_id) = p_person
1458: AND pei.information_type = 'PAY_CA_RL1_FORM_NO'