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.

APPS.PAY_US_WEB_W4 dependencies on PER_PEOPLE_EXTRA_INFO

Line 984: from per_people_extra_info where person_id=p_person_id

980: --added by vaprakas 11/21/06 Bug 5607135
981: cursor csr_chk_NRA_status
982: is
983: select information_type,pei_information_category,pei_information5,pei_information9
984: from per_people_extra_info where person_id=p_person_id
985: and information_type like 'PER_US_ADDITIONAL_DETAILS'
986: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'
987: and pei_information5 like 'N'
988: and pei_information9 not in ('US');

Line 993: from per_people_extra_info where person_id=p_person_id

989:
990: cursor csr_chk_student_status
991: is
992: select pei_information1,pei_information2
993: from per_people_extra_info where person_id=p_person_id
994: and information_type like 'PER_US_ADDITIONAL_DETAILS'
995: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'
996: and (pei_information1 = 'Y'
997: or pei_information2 = 'Y');

Line 1000: l_information_type per_people_extra_info.information_type%TYPE;

996: and (pei_information1 = 'Y'
997: or pei_information2 = 'Y');
998:
999:
1000: l_information_type per_people_extra_info.information_type%TYPE;
1001: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
1004: l_student_flag varchar2(3);

Line 1001: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;

997: or pei_information2 = 'Y');
998:
999:
1000: l_information_type per_people_extra_info.information_type%TYPE;
1001: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
1004: l_student_flag varchar2(3);
1005: l_student per_people_extra_info.pei_information1%TYPE;

Line 1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;

998:
999:
1000: l_information_type per_people_extra_info.information_type%TYPE;
1001: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
1004: l_student_flag varchar2(3);
1005: l_student per_people_extra_info.pei_information1%TYPE;
1006: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

Line 1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;

999:
1000: l_information_type per_people_extra_info.information_type%TYPE;
1001: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
1004: l_student_flag varchar2(3);
1005: l_student per_people_extra_info.pei_information1%TYPE;
1006: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
1007:

Line 1005: l_student per_people_extra_info.pei_information1%TYPE;

1001: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
1004: l_student_flag varchar2(3);
1005: l_student per_people_extra_info.pei_information1%TYPE;
1006: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
1007:
1008: ln_prev_comma_position NUMBER;
1009: ln_comma_position NUMBER;

Line 1006: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

1002: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
1003: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
1004: l_student_flag varchar2(3);
1005: l_student per_people_extra_info.pei_information1%TYPE;
1006: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
1007:
1008: ln_prev_comma_position NUMBER;
1009: ln_comma_position NUMBER;
1010: lv_notmatch_state pay_us_states.state_name%TYPE;