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 779: to_char(nvl(fnd_date.canonical_to_date(pei.pei_information13)

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

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

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

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

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

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

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

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

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

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

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

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

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') <=
1106: to_char(nvl(fnd_date.canonical_to_date(pei_information13)
1107: ,to_date('31/12/4712','DD/MM/YYYY')
1108: ),'YYYY'
1109: )
1110: )

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

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),
1127: TO_DATE('31/12/4712','DD/MM/YYYY')),'YYYY')
1128: ) ppei ,
1129: pay_process_events ppe
1130: where ppf.person_id = paf.person_id

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

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

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

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

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

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

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

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

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

2156: c_additional.dep_children_total;
2157: end if;
2158:
2159: t_people_tab(i).date_first_entered_us :=
2160: fnd_date.canonical_to_date(c_additional.first_entry_date);
2161: end loop;
2162:
2163: hr_utility.set_location(l_proc, 80);
2164: --

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

2512: c_additional.dep_children_total;
2513: end if;
2514:
2515: t_people_tab(i).date_first_entered_us :=
2516: fnd_date.canonical_to_date(c_additional.first_entry_date);
2517: end loop;
2518:
2519: hr_utility.set_location(l_proc, 230);
2520:

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

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

Line 3992: fnd_date.canonical_to_date(pei_information7) visa_issue_date ,

3988: cursor c_person_visa_info(p_person_id in number,
3989: p_visa_no in varchar2) is
3990: select pei_information5 visa_type ,
3991: SUBSTR(pei_information6, 1, 20) visa_number ,
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

Line 3993: fnd_date.canonical_to_date(pei_information8) visa_expiry_date ,

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

Line 4010: fnd_date.canonical_to_date(pei_information7) start_date ,

4006: person id.
4007: ****/
4008: cursor c_person_visit_visa_info(p_person_id in number ) is
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'

Line 4011: fnd_date.canonical_to_date(pei_information8) end_date ,

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