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 FND_DATE

Line 87: and (to_char(fnd_date.canonical_to_date(ppei.pei_information7),'YYYY')=

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'
87: and (to_char(fnd_date.canonical_to_date(ppei.pei_information7),'YYYY')=
88: to_char(p_effective_date, 'YYYY')
89: or
90: to_char(fnd_date.canonical_to_date(ppei.pei_information8),'YYYY')=
91: to_char(p_effective_date, 'YYYY')

Line 90: to_char(fnd_date.canonical_to_date(ppei.pei_information8),'YYYY')=

86: and ppei.information_type = 'PER_US_VISIT_HISTORY'
87: and (to_char(fnd_date.canonical_to_date(ppei.pei_information7),'YYYY')=
88: to_char(p_effective_date, 'YYYY')
89: or
90: to_char(fnd_date.canonical_to_date(ppei.pei_information8),'YYYY')=
91: to_char(p_effective_date, 'YYYY')
92: or
93: p_effective_date
94: between fnd_date.canonical_to_date(ppei.pei_information7)

Line 94: between fnd_date.canonical_to_date(ppei.pei_information7)

90: to_char(fnd_date.canonical_to_date(ppei.pei_information8),'YYYY')=
91: to_char(p_effective_date, 'YYYY')
92: or
93: p_effective_date
94: between fnd_date.canonical_to_date(ppei.pei_information7)
95: and nvl(fnd_date.canonical_to_date(ppei.pei_information8),
96: to_date('12/31/4712','MM/DD/YYYY')
97: )
98: )

Line 95: and nvl(fnd_date.canonical_to_date(ppei.pei_information8),

91: to_char(p_effective_date, 'YYYY')
92: or
93: p_effective_date
94: between fnd_date.canonical_to_date(ppei.pei_information7)
95: and nvl(fnd_date.canonical_to_date(ppei.pei_information8),
96: to_date('12/31/4712','MM/DD/YYYY')
97: )
98: )
99: order by 4 asc;

Line 780: to_char(nvl(fnd_date.canonical_to_date(pei.pei_information13)

776: and paf.assignment_type <> 'B' --RLN
777: and pei.information_type = 'PER_US_ADDITIONAL_DETAILS'
778: and pei.pei_information12 = 'WINDSTAR'
779: and to_char(c_effective_date, 'YYYY') <=
780: to_char(nvl(fnd_date.canonical_to_date(pei.pei_information13)
781: ,to_date('31/12/4712','DD/MM/YYYY')
782: ),'YYYY'
783: )
784: --

Line 833: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),

829: and ppf.person_id = ppei.person_id
830: and ppei.information_type = 'PER_US_ADDITIONAL_DETAILS'
831: and ppei.pei_information12 = 'WINDSTAR'
832: and TO_CHAR(p_effective_date, 'YYYY') <=
833: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),
834: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
835: and paf.person_id = ppf.person_id
836: and paf.effective_start_date <= TO_DATE(('12/31/' ||
837: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')

Line 886: to_char(nvl(fnd_date.canonical_to_date(pei_information13)

882: and pei.person_id = ppf.person_id
883: and pei.information_type = 'PER_US_ADDITIONAL_DETAILS'
884: and pei.pei_information12 = 'WINDSTAR'
885: and to_char(c_effective_date, 'YYYY') <=
886: to_char(nvl(fnd_date.canonical_to_date(pei_information13)
887: ,to_date('31/12/4712','DD/MM/YYYY')
888: ),'YYYY'
889: )
890: --

Line 937: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),

933: and ppf.person_id = ppei.person_id
934: and ppei.information_type = 'PER_US_ADDITIONAL_DETAILS'
935: and ppei.pei_information12 = 'WINDSTAR'
936: and TO_CHAR(p_effective_date, 'YYYY') <=
937: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),
938: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
939: and paf.effective_start_date <= TO_DATE(('12/31/' ||
940: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')
941: and paf.effective_end_date >= TO_DATE(('01/01/' ||

Line 1005: to_char(nvl(fnd_date.canonical_to_date(pei_information13)

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') <=
1005: to_char(nvl(fnd_date.canonical_to_date(pei_information13)
1006: ,to_date('31/12/4712','DD/MM/YYYY')
1007: ),'YYYY'
1008: )
1009: )

Line 1022: TO_CHAR(NVL(fnd_date.canonical_to_date(pei_information13),

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),
1023: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
1024: ) ppei
1025: where ppf.person_id = paf.person_id
1026: and ppf.person_type_id = ppt.person_type_id

Line 1110: to_char(nvl(fnd_date.canonical_to_date(pei_information13)

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') <=
1110: to_char(nvl(fnd_date.canonical_to_date(pei_information13)
1111: ,to_date('31/12/4712','DD/MM/YYYY')
1112: ),'YYYY'
1113: )
1114: )

Line 1130: TO_CHAR(NVL(fnd_date.canonical_to_date(pei_information13),

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),
1131: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
1132: ) ppei ,
1133: pay_process_events ppe
1134: where ppf.person_id = paf.person_id

Line 1641: to_char(nvl(fnd_date.canonical_to_date(pei.pei_information13),

1637: and ppf.person_id = pei.person_id
1638: and pei.information_type = 'PER_US_ADDITIONAL_DETAILS'
1639: and pei.pei_information12 = 'WINDSTAR'
1640: and to_char(c_year_end_date, 'YYYY') <=
1641: to_char(nvl(fnd_date.canonical_to_date(pei.pei_information13),
1642: c_year_end_date),'YYYY')
1643: and ((c_year_end_date between paf.effective_start_date
1644: and paf.effective_end_date
1645: )

Line 1698: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),

1694: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY'))
1695: and ppei.information_type = 'PER_US_ADDITIONAL_DETAILS'
1696: and ppei.pei_information12 = 'WINDSTAR'
1697: and TO_CHAR(p_effective_date, 'YYYY') <=
1698: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),
1699: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
1700:
1701: and paf.effective_start_date <= TO_DATE(('12/31/' ||
1702: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')

Line 1758: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),

1754: and ppf.person_id = ppei.person_id
1755: and ppei.information_type = 'PER_US_ADDITIONAL_DETAILS'
1756: and ppei.pei_information12 = 'WINDSTAR'
1757: and TO_CHAR(p_effective_date, 'YYYY') <=
1758: TO_CHAR(NVL(fnd_date.canonical_to_date(ppei.pei_information13),
1759: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
1760: order by ppf.person_id ;
1761:
1762: /*****

Line 1785: TO_CHAR(NVL(fnd_date.canonical_to_date(pei_information13),

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),
1786: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
1787: ) ppei
1788: where ppf.person_type_id = ppt.person_type_id
1789: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')

Line 2164: fnd_date.canonical_to_date(c_additional.first_entry_date);

2160: c_additional.dep_children_total;
2161: end if;
2162:
2163: t_people_tab(i).date_first_entered_us :=
2164: fnd_date.canonical_to_date(c_additional.first_entry_date);
2165: end loop;
2166:
2167: hr_utility.set_location(l_proc, 80);
2168: --

Line 2520: fnd_date.canonical_to_date(c_additional.first_entry_date);

2516: c_additional.dep_children_total;
2517: end if;
2518:
2519: t_people_tab(i).date_first_entered_us :=
2520: fnd_date.canonical_to_date(c_additional.first_entry_date);
2521: end loop;
2522:
2523: hr_utility.set_location(l_proc, 230);
2524:

Line 2838: fnd_date.canonical_to_date(c_additional.first_entry_date);

2834: c_additional.dep_children_total;
2835: end if;
2836:
2837: t_people_tab(i).date_first_entered_us :=
2838: fnd_date.canonical_to_date(c_additional.first_entry_date);
2839: end loop;
2840: hr_utility.set_location(l_proc, 400);
2841:
2842: /* Added the code to fetch the complete non us address - tmehra 15-OCT-2001 */

Line 4007: fnd_date.canonical_to_date(pei_information7) visa_issue_date ,

4003: cursor c_person_visa_info(p_person_id in number,
4004: p_visa_no in varchar2) is
4005: select pei_information5 visa_type ,
4006: SUBSTR(pei_information6, 1, 20) visa_number ,
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

Line 4008: fnd_date.canonical_to_date(pei_information8) visa_expiry_date ,

4004: p_visa_no in varchar2) is
4005: select pei_information5 visa_type ,
4006: SUBSTR(pei_information6, 1, 20) visa_number ,
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' )

Line 4025: fnd_date.canonical_to_date(pei_information7) start_date ,

4021: person id.
4022: ****/
4023: cursor c_person_visit_visa_info(p_person_id in number ) is
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'

Line 4026: fnd_date.canonical_to_date(pei_information8) end_date ,

4022: ****/
4023: cursor c_person_visit_visa_info(p_person_id in number ) is
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 )