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 814: per_people_extra_info ppei,

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

Line 868: ,per_people_extra_info pei

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

Line 916: per_people_extra_info ppei,

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

Line 997: from per_people_extra_info pei

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

Line 1015: (select * from per_people_extra_info

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

Line 1101: from per_people_extra_info pei

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

Line 1122: (select * from per_people_extra_info

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

Line 1623: ,per_people_extra_info pei

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

Line 1679: per_people_extra_info ppei

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

Line 1736: per_people_extra_info ppei

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

Line 1777: (select * from per_people_extra_info

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

Line 1814: from per_people_extra_info

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

Line 3267: from per_people_extra_info

3263: select pei_information5 income_code ,
3264: pei_information6 prev_er_treaty_ben_amt ,
3265: pei_information7 prev_er_treaty_ben_year
3266: from (select *
3267: from per_people_extra_info
3268: where information_type = 'PER_US_PAYROLL_DETAILS'
3269: and person_id = p_person_id )
3270: where pei_information7 = p_year
3271: and pei_information5 = p_income_code;

Line 3377: from per_people_extra_info

3373: cursor c_forecasted_income_code(p_person_id in number
3374: ,p_assignment_id in number
3375: ,p_effective_date in date) is
3376: select pei_information5 income_code
3377: from per_people_extra_info
3378: where person_id = p_person_id
3379: and information_type = 'PER_US_INCOME_FORECAST'
3380: and pei_information8 = to_char(p_effective_date, 'YYYY');
3381:

Line 3996: from (select * from per_people_extra_info

3992: fnd_date.canonical_to_date(pei_information7) visa_issue_date ,
3993: fnd_date.canonical_to_date(pei_information8) visa_expiry_date ,
3994: pei_information9 visa_category ,
3995: pei_information10 current_status
3996: from (select * from per_people_extra_info
3997: where information_type = 'PER_US_VISA_DETAILS' )
3998: where person_id = p_person_id
3999: and information_type = 'PER_US_VISA_DETAILS'
4000: and pei_information6 = NVL(p_visa_no, pei_information6)

Line 4013: from (select * from per_people_extra_info

4009: select pei_information5 purpose ,
4010: fnd_date.canonical_to_date(pei_information7) start_date ,
4011: fnd_date.canonical_to_date(pei_information8) end_date ,
4012: pei_information11 visa_number
4013: from (select * from per_people_extra_info
4014: where information_type = 'PER_US_VISIT_HISTORY'
4015: and person_id = p_person_id )
4016: order by 2 asc,
4017: 3 asc;

Line 4028: from per_people_extra_info

4024: cursor c_visa_count(p_person_id in number ) is
4025: select count(*) ct
4026: from
4027: (select *
4028: from per_people_extra_info
4029: where information_type = 'PER_US_VISA_DETAILS') visa
4030: where visa.person_id = p_person_id;
4031:
4032:

Line 4041: from per_people_extra_info

4037: cursor c_validate_visa_number(p_person_id in number ) is
4038: select visa.visa_number
4039: from
4040: (select *
4041: from per_people_extra_info
4042: where information_type = 'PER_US_ADDITIONAL_DETAILS'
4043: and pei_information12 = 'WINDSTAR') pei,
4044: (select person_id,
4045: SUBSTR(pei_information6, 1, 20) visa_number

Line 4046: from per_people_extra_info

4042: where information_type = 'PER_US_ADDITIONAL_DETAILS'
4043: and pei_information12 = 'WINDSTAR') pei,
4044: (select person_id,
4045: SUBSTR(pei_information6, 1, 20) visa_number
4046: from per_people_extra_info
4047: where information_type = 'PER_US_VISA_DETAILS') visa
4048: where visa.person_id = pei.person_id
4049: and pei.person_id = p_person_id
4050: and not exists

Line 4052: from per_people_extra_info

4048: where visa.person_id = pei.person_id
4049: and pei.person_id = p_person_id
4050: and not exists
4051: (select 'X'
4052: from per_people_extra_info
4053: where information_type = 'PER_US_VISIT_HISTORY'
4054: and person_id = visa.person_id
4055: and SUBSTR(pei_information11, 1, 20) = visa.visa_number
4056: );

Line 5076: from per_people_extra_info

5072: --
5073: cursor c_person_residency_status(p_person_id in number) is
5074: select pei_information5 residency_status
5075: ,person_extra_info_id
5076: from per_people_extra_info
5077: where information_type = 'PER_US_ADDITIONAL_DETAILS'
5078: and person_id = p_person_id;
5079:
5080: --

Line 5753: update per_people_extra_info

5749:
5750: for c_rec in c_person_residency_status(l_person_id)
5751: loop
5752: if p_residency_status <> c_rec.residency_status then
5753: update per_people_extra_info
5754: set pei_information5 = p_residency_status
5755: where person_extra_info_id = c_rec.person_extra_info_id;
5756: end if;
5757: end loop;