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_EMP_DT_TAX_RULES dependencies on PER_PEOPLE_EXTRA_INFO

Line 12425: l_information_type per_people_extra_info.information_type%TYPE;

12421: p_effective_start_date in date,
12422: p_effective_end_date in date,
12423: p_returned_warning OUT NOCOPY VARCHAR2)
12424: is
12425: l_information_type per_people_extra_info.information_type%TYPE;
12426: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
12427: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
12429:

Line 12426: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;

12422: p_effective_end_date in date,
12423: p_returned_warning OUT NOCOPY VARCHAR2)
12424: is
12425: l_information_type per_people_extra_info.information_type%TYPE;
12426: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
12427: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
12429:
12430: l_student_flag varchar2(3);

Line 12427: l_pei_information5 per_people_extra_info.pei_information5%TYPE;

12423: p_returned_warning OUT NOCOPY VARCHAR2)
12424: is
12425: l_information_type per_people_extra_info.information_type%TYPE;
12426: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
12427: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
12429:
12430: l_student_flag varchar2(3);
12431: l_student per_people_extra_info.pei_information1%TYPE;

Line 12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;

12424: is
12425: l_information_type per_people_extra_info.information_type%TYPE;
12426: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
12427: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
12429:
12430: l_student_flag varchar2(3);
12431: l_student per_people_extra_info.pei_information1%TYPE;
12432: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

Line 12431: l_student per_people_extra_info.pei_information1%TYPE;

12427: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
12429:
12430: l_student_flag varchar2(3);
12431: l_student per_people_extra_info.pei_information1%TYPE;
12432: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
12433: l_warning VARCHAR2(300);
12434:
12435:

Line 12432: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

12428: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
12429:
12430: l_student_flag varchar2(3);
12431: l_student per_people_extra_info.pei_information1%TYPE;
12432: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
12433: l_warning VARCHAR2(300);
12434:
12435:
12436: cursor csr_chk_student_status

Line 12439: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f

12435:
12436: cursor csr_chk_student_status
12437: is
12438: select pei_information1,pei_information2
12439: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f
12440: where assignment_id=p_assignment_id
12441: and primary_flag='Y')
12442: and information_type like 'PER_US_ADDITIONAL_DETAILS'
12443: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'

Line 12450: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f

12446:
12447: cursor csr_chk_nra_status
12448: is
12449: select information_type,pei_information_category,pei_information5,pei_information9
12450: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f
12451: where assignment_id=p_assignment_id
12452: and primary_flag='Y')
12453: and information_type like 'PER_US_ADDITIONAL_DETAILS'
12454: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'