eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_CA_RL2_AMEND_MAG dependencies on PER_PEOPLE_EXTRA_INFO

Line 1453: FROM per_people_extra_info pei

1449: /* Bug 15972601 - Removed join with per_people_f table due
1450: to which duplicate records are fetched. */
1451: CURSOR c_original_slipno (p_person IN VARCHAR,p_tax_year IN VARCHAR,p_trans_id IN NUMBER) IS
1452: SELECT pei_information7
1453: FROM per_people_extra_info pei
1454: WHERE pei_information6=to_char(p_trans_id)
1455: AND substr(pei_information5,1,4)=p_tax_year
1456: AND to_number(pei.person_id) = to_number(p_person)
1457: AND pei.information_type = 'PAY_CA_RL2_FORM_NO'