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.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 82: from per_people_extra_info

78: ,pei_information8 end_date
79: ,pei_information9 spouse_accompanied
80: ,pei_information10 child_accompanied
81: from (select *
82: from per_people_extra_info
83: where information_type = 'PER_US_VISIT_HISTORY'
84: ) ppei
85: where ppei.person_id = p_person_id
86: and ppei.information_type = 'PER_US_VISIT_HISTORY'

Line 119: from per_people_extra_info

115: ,nvl(pei_information10, 0) dep_children_total
116: ,nvl(pei_information11, 0) dep_children_in_cntry
117: ,pei_information9 tax_res_country_code
118: from (select *
119: from per_people_extra_info
120: where information_type = 'PER_US_ADDITIONAL_DETAILS'
121: and person_id = p_person_id );
122: --
123: -- The cursor below selects the object version number in pay_process_events table.

Line 289: from per_people_extra_info

285: --
286: cursor c2 is
287: select pei_information7 amount
288: from (select *
289: from per_people_extra_info
290: where person_id = p_person_id
291: and information_type = 'PER_US_INCOME_FORECAST'
292: )
293: where pei_information5 = p_income_code

Line 769: ,per_people_extra_info pei

765: select paf.assignment_id
766: ,paf.effective_start_date
767: from per_people_f ppf
768: ,per_person_types ppt
769: ,per_people_extra_info pei
770: ,per_all_assignments_f paf
771: where ppf.person_type_id = ppt.person_type_id
772: and ppf.business_group_id = ppt.business_group_id
773: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')

Line 815: per_people_extra_info ppei,

811: select paf.assignment_id ,
812: paf.effective_start_date
813: from per_people_f ppf ,
814: per_person_types ppt ,
815: per_people_extra_info ppei,
816: per_assignments_f paf
817: where ppf.person_type_id = ppt.person_type_id
818: and ppt.system_person_type in ('EMP' , 'EX_EMP')
819: and ppf.effective_start_date <=

Line 869: ,per_people_extra_info pei

865: ,ppe.object_version_number
866:
867: from per_people_f ppf
868: ,per_person_types ppt
869: ,per_people_extra_info pei
870: ,pay_process_events ppe
871: ,per_all_assignments_f paf
872:
873: where ppt.person_type_id = ppf.person_type_id

Line 918: per_people_extra_info ppei,

914: ppe.process_event_id ,
915: ppe.object_version_number
916: from per_people_f ppf ,
917: per_person_types ppt ,
918: per_people_extra_info ppei,
919: pay_process_events ppe ,
920: per_assignments_f paf
921: where ppf.person_type_id = ppt.person_type_id
922: and ppt.system_person_type in ('EMP' , 'EX_EMP')

Line 1000: from per_people_extra_info pei

996: and change_type = 'PQP_US_ALIEN_WINDSTAR'
997: )
998: and exists
999: (select 1
1000: from per_people_extra_info pei
1001: where pei.information_type = 'PER_US_ADDITIONAL_DETAILS'
1002: and pei.pei_information12 = 'WINDSTAR'
1003: and pei.person_id = ppf.person_id
1004: and to_char(c_effective_date, 'YYYY') <=

Line 1018: (select * from per_people_extra_info

1014: paf.effective_start_date
1015: from per_assignments_f paf ,
1016: per_people_f ppf ,
1017: per_person_types ppt ,
1018: (select * from per_people_extra_info
1019: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1020: and pei_information12 = 'WINDSTAR'
1021: and TO_CHAR(p_effective_date, 'YYYY') <=
1022: TO_CHAR(NVL(fnd_date.canonical_to_date(pei_information13),

Line 1105: from per_people_extra_info pei

1101: and ppe.assignment_id = paf.assignment_id
1102: and ppe.status in ('D')
1103: and ppe.change_type = 'PQP_US_ALIEN_WINDSTAR'
1104: and exists (select 1
1105: from per_people_extra_info pei
1106: where pei.information_type = 'PER_US_ADDITIONAL_DETAILS'
1107: and pei.pei_information12 = 'WINDSTAR'
1108: and pei.person_id = ppf.person_id
1109: and to_char(c_effective_date, 'YYYY') <=

Line 1126: (select * from per_people_extra_info

1122:
1123: from per_assignments_f paf ,
1124: per_people_f ppf ,
1125: per_person_types ppt ,
1126: (select * from per_people_extra_info
1127: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1128: and pei_information12 = 'WINDSTAR'
1129: and TO_CHAR(p_effective_date, 'YYYY') <=
1130: TO_CHAR(NVL(fnd_date.canonical_to_date(pei_information13),

Line 1627: ,per_people_extra_info pei

1623: from per_all_assignments_f paf
1624: ,per_people_f ppf
1625: ,pay_process_events ppe
1626: ,per_person_types ppt
1627: ,per_people_extra_info pei
1628:
1629: where ppf.person_id = paf.person_id
1630: and ppf.person_type_id = ppt.person_type_id
1631: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')

Line 1683: per_people_extra_info ppei

1679: from per_assignments_f paf ,
1680: per_people_f ppf ,
1681: pay_process_events ppe ,
1682: per_person_types ppt ,
1683: per_people_extra_info ppei
1684: where ppf.person_id = paf.person_id
1685: and ppf.effective_start_date <= TO_DATE(('12/31/' ||
1686: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')
1687: and ppf.effective_end_date >= TO_DATE(('01/01/' ||

Line 1740: per_people_extra_info ppei

1736: UPPER(ppf.marital_status) ,
1737: ppf.person_id
1738: from per_people_f ppf ,
1739: per_person_types ppt ,
1740: per_people_extra_info ppei
1741: where ppf.person_type_id = ppt.person_type_id
1742: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')
1743: and ppf.effective_start_date <=
1744: TO_DATE(('12/31/' || TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')

Line 1781: (select * from per_people_extra_info

1777: UPPER(ppf.marital_status) ,
1778: ppf.person_id
1779: from per_people_f ppf ,
1780: per_person_types ppt ,
1781: (select * from per_people_extra_info
1782: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1783: and pei_information12 = 'WINDSTAR'
1784: and TO_CHAR(p_effective_date, 'YYYY') <=
1785: TO_CHAR(NVL(fnd_date.canonical_to_date(pei_information13),

Line 1818: from per_people_extra_info

1814: ppei.pei_information6 passport_number ,
1815: ppei.pei_information7 issue_date ,
1816: ppei.pei_information8 expiry_date
1817: from (select *
1818: from per_people_extra_info
1819: where information_type = 'PER_US_PASSPORT_DETAILS'
1820: and person_id = p_person_id) ppei
1821: where rownum < 2;
1822:

Line 3272: from per_people_extra_info

3268: select pei_information5 income_code ,
3269: pei_information6 prev_er_treaty_ben_amt ,
3270: pei_information7 prev_er_treaty_ben_year
3271: from (select *
3272: from per_people_extra_info
3273: where information_type = 'PER_US_PAYROLL_DETAILS'
3274: and person_id = p_person_id )
3275: where pei_information7 = p_year
3276: and pei_information5 = p_income_code;

Line 3383: from per_people_extra_info

3379: cursor c_forecasted_income_code(p_person_id in number
3380: ,p_assignment_id in number
3381: ,p_effective_date in date) is
3382: select pei_information5 income_code
3383: from per_people_extra_info
3384: where person_id = p_person_id
3385: and information_type = 'PER_US_INCOME_FORECAST'
3386: and pei_information8 = to_char(p_effective_date, 'YYYY');
3387:

Line 4011: from (select * from per_people_extra_info

4007: fnd_date.canonical_to_date(pei_information7) visa_issue_date ,
4008: fnd_date.canonical_to_date(pei_information8) visa_expiry_date ,
4009: pei_information9 visa_category ,
4010: pei_information10 current_status
4011: from (select * from per_people_extra_info
4012: where information_type = 'PER_US_VISA_DETAILS' )
4013: where person_id = p_person_id
4014: and information_type = 'PER_US_VISA_DETAILS'
4015: and pei_information6 = NVL(p_visa_no, pei_information6)

Line 4028: from (select * from per_people_extra_info

4024: select pei_information5 purpose ,
4025: fnd_date.canonical_to_date(pei_information7) start_date ,
4026: fnd_date.canonical_to_date(pei_information8) end_date ,
4027: pei_information11 visa_number
4028: from (select * from per_people_extra_info
4029: where information_type = 'PER_US_VISIT_HISTORY'
4030: and person_id = p_person_id )
4031: order by 2 asc,
4032: 3 asc;

Line 4043: from per_people_extra_info

4039: cursor c_visa_count(p_person_id in number ) is
4040: select count(*) ct
4041: from
4042: (select *
4043: from per_people_extra_info
4044: where information_type = 'PER_US_VISA_DETAILS') visa
4045: where visa.person_id = p_person_id;
4046:
4047:

Line 4056: from per_people_extra_info

4052: cursor c_validate_visa_number(p_person_id in number ) is
4053: select visa.visa_number
4054: from
4055: (select *
4056: from per_people_extra_info
4057: where information_type = 'PER_US_ADDITIONAL_DETAILS'
4058: and pei_information12 = 'WINDSTAR') pei,
4059: (select person_id,
4060: SUBSTR(pei_information6, 1, 20) visa_number

Line 4061: from per_people_extra_info

4057: where information_type = 'PER_US_ADDITIONAL_DETAILS'
4058: and pei_information12 = 'WINDSTAR') pei,
4059: (select person_id,
4060: SUBSTR(pei_information6, 1, 20) visa_number
4061: from per_people_extra_info
4062: where information_type = 'PER_US_VISA_DETAILS') visa
4063: where visa.person_id = pei.person_id
4064: and pei.person_id = p_person_id
4065: and not exists

Line 4067: from per_people_extra_info

4063: where visa.person_id = pei.person_id
4064: and pei.person_id = p_person_id
4065: and not exists
4066: (select 'X'
4067: from per_people_extra_info
4068: where information_type = 'PER_US_VISIT_HISTORY'
4069: and person_id = visa.person_id
4070: and SUBSTR(pei_information11, 1, 20) = visa.visa_number
4071: );

Line 5091: from per_people_extra_info

5087: --
5088: cursor c_person_residency_status(p_person_id in number) is
5089: select pei_information5 residency_status
5090: ,person_extra_info_id
5091: from per_people_extra_info
5092: where information_type = 'PER_US_ADDITIONAL_DETAILS'
5093: and person_id = p_person_id;
5094:
5095: --

Line 5768: update per_people_extra_info

5764:
5765: for c_rec in c_person_residency_status(l_person_id)
5766: loop
5767: if p_residency_status <> c_rec.residency_status then
5768: update per_people_extra_info
5769: set pei_information5 = p_residency_status
5770: where person_extra_info_id = c_rec.person_extra_info_id;
5771: end if;
5772: end loop;