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.PER_PERUSHRM_XMLP_PKG dependencies on FND_DATE

Line 100: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);

96:
97: if p_state_code = 'TX' or p_state_code = 'OR'
98: or p_state_code = 'MD' then
99: l_business_group_id := P_BUSINESS_GROUP_ID;
100: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
101:
102: l_salary := hr_us_reports.get_salary(l_business_group_id,
103: assignment_id,
104: l_report_date

Line 772: And fnd_date.canonical_to_date(P_REPORT_DATE)

768: ,hr_organization_units hou
769: Where
770: pps.person_id = ppf.person_id
771:
772: And fnd_date.canonical_to_date(P_REPORT_DATE)
773: between pps.date_start and NVL(pps.actual_termination_date,C_END_OF_TIME)
774: And fnd_date.canonical_to_date(P_REPORT_DATE)
775: between ppf.effective_start_date and ppf.effective_end_date
776: And ppf.person_id = paf.person_id

Line 774: And fnd_date.canonical_to_date(P_REPORT_DATE)

770: pps.person_id = ppf.person_id
771:
772: And fnd_date.canonical_to_date(P_REPORT_DATE)
773: between pps.date_start and NVL(pps.actual_termination_date,C_END_OF_TIME)
774: And fnd_date.canonical_to_date(P_REPORT_DATE)
775: between ppf.effective_start_date and ppf.effective_end_date
776: And ppf.person_id = paf.person_id
777: And fnd_date.canonical_to_date(P_REPORT_DATE)
778: between paf.effective_start_date and paf.effective_end_date

Line 777: And fnd_date.canonical_to_date(P_REPORT_DATE)

773: between pps.date_start and NVL(pps.actual_termination_date,C_END_OF_TIME)
774: And fnd_date.canonical_to_date(P_REPORT_DATE)
775: between ppf.effective_start_date and ppf.effective_end_date
776: And ppf.person_id = paf.person_id
777: And fnd_date.canonical_to_date(P_REPORT_DATE)
778: between paf.effective_start_date and paf.effective_end_date
779:
780: and hscf.segment1 = to_char(hou.organization_id)
781: and hou.business_group_id = p_business_group_id

Line 792: And pps.date_start <= fnd_date.canonical_to_date(P_REPORT_DATE)

788:
789:
790: And ppf.business_group_id +0 = P_BUSINESS_GROUP_ID
791: And ppf.per_information_category = 'US'
792: And pps.date_start <= fnd_date.canonical_to_date(P_REPORT_DATE)
793: And ppf.per_information7 = 'INCL'
794: and hou.business_group_id = ppf.business_group_id
795: and hoi1.organization_id = hou.organization_id
796: and hoi1.org_information_context = 'CLASS'

Line 827: And fnd_date.canonical_to_date(P_REPORT_DATE)

823: ,hr_organization_units hou
824: Where
825: pps.person_id = ppf.person_id
826:
827: And fnd_date.canonical_to_date(P_REPORT_DATE)
828: between ppf.effective_start_date and ppf.effective_end_date
829: And pps.actual_termination_date IS NOT NULL
830: And ppf.person_id = paf.person_id
831: And not exists (select 1 from per_all_assignments_f paf2

Line 833: and fnd_date.canonical_to_date(P_REPORT_DATE)

829: And pps.actual_termination_date IS NOT NULL
830: And ppf.person_id = paf.person_id
831: And not exists (select 1 from per_all_assignments_f paf2
832: where ppf.person_id = paf2.person_id
833: and fnd_date.canonical_to_date(P_REPORT_DATE)
834: between paf2.effective_start_date and paf2.effective_end_date
835: )
836: And pps.date_start = paf.effective_start_date
837:

Line 850: And pps.date_start <= fnd_date.canonical_to_date(P_REPORT_DATE)

846:
847:
848: And ppf.business_group_id +0 = P_BUSINESS_GROUP_ID
849: And ppf.per_information_category = 'US'
850: And pps.date_start <= fnd_date.canonical_to_date(P_REPORT_DATE)
851: And ppf.per_information7 = 'INCL'
852: and hou.business_group_id = ppf.business_group_id
853: and hoi1.organization_id = hou.organization_id
854: and hoi1.org_information_context = 'CLASS'

Line 982: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);

978:
979: begin
980:
981: l_person_id := new_hire_contact_id;
982: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
983: l_business_group_id := P_BUSINESS_GROUP_ID;
984:
985: per_new_hire_pkg.get_new_hire_contact
986: (l_person_id,

Line 1026: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);

1022:
1023: begin
1024:
1025: l_person_id := new_hire_contact_id;
1026: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
1027: l_business_group_id := P_BUSINESS_GROUP_ID;
1028:
1029: per_new_hire_pkg.get_new_hire_contact
1030: (l_person_id,

Line 1069: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);

1065:
1066: begin
1067:
1068: l_person_id := new_hire_contact_id;
1069: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
1070: l_business_group_id := P_BUSINESS_GROUP_ID;
1071:
1072: per_new_hire_pkg.get_new_hire_contact
1073: (l_person_id,

Line 1202: And fnd_date.canonical_to_date(P_REPORT_DATE)

1198: ,hr_organization_units hou
1199:
1200: Where
1201: pps.person_id = ppf.person_id
1202: And fnd_date.canonical_to_date(P_REPORT_DATE)
1203: between pps.date_start and NVL(pps.actual_termination_date, C_END_OF_TIME)
1204: And fnd_date.canonical_to_date(P_REPORT_DATE)
1205: between ppf.effective_start_date and ppf.effective_end_date
1206: And ppf.person_id = paf.person_id

Line 1204: And fnd_date.canonical_to_date(P_REPORT_DATE)

1200: Where
1201: pps.person_id = ppf.person_id
1202: And fnd_date.canonical_to_date(P_REPORT_DATE)
1203: between pps.date_start and NVL(pps.actual_termination_date, C_END_OF_TIME)
1204: And fnd_date.canonical_to_date(P_REPORT_DATE)
1205: between ppf.effective_start_date and ppf.effective_end_date
1206: And ppf.person_id = paf.person_id
1207: And fnd_date.canonical_to_date(P_REPORT_DATE)
1208: between paf.effective_start_date and paf.effective_end_date

Line 1207: And fnd_date.canonical_to_date(P_REPORT_DATE)

1203: between pps.date_start and NVL(pps.actual_termination_date, C_END_OF_TIME)
1204: And fnd_date.canonical_to_date(P_REPORT_DATE)
1205: between ppf.effective_start_date and ppf.effective_end_date
1206: And ppf.person_id = paf.person_id
1207: And fnd_date.canonical_to_date(P_REPORT_DATE)
1208: between paf.effective_start_date and paf.effective_end_date
1209:
1210: And hscf.segment1 = to_char(hou.organization_id)
1211: and hou.business_group_id = P_BUSINESS_GROUP_ID

Line 1219: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)

1215: And paf.assignment_type = 'E'
1216: And paf.primary_flag = 'Y'
1217: And paf.location_id = hl.location_id
1218: And paf.job_id = job.job_id(+)
1219: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1220: and nvl(job.date_to, C_END_OF_TIME)
1221: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1222: And ppf.per_information_category = 'US'
1223: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1223: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

1219: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1220: and nvl(job.date_to, C_END_OF_TIME)
1221: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1222: And ppf.per_information_category = 'US'
1223: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)
1224: And ppf.per_information7 = 'INCL' And hou.business_group_id = ppf.business_group_id
1225: AND hoi1.organization_id = hou.organization_id
1226: AND hoi1.org_information_context = 'CLASS'
1227: AND hoi1.org_information1 = 'HR_LEGAL'

Line 1257: And fnd_date.canonical_to_date(P_REPORT_DATE)

1253:
1254: Where
1255: pps.person_id = ppf.person_id
1256:
1257: And fnd_date.canonical_to_date(P_REPORT_DATE)
1258: between ppf.effective_start_date and ppf.effective_end_date
1259: And ppf.person_id = paf.person_id
1260: And not exists (select 1 from per_all_assignments_f paf2
1261: where ppf.person_id = paf2.person_id

Line 1262: and fnd_date.canonical_to_date(P_REPORT_DATE)

1258: between ppf.effective_start_date and ppf.effective_end_date
1259: And ppf.person_id = paf.person_id
1260: And not exists (select 1 from per_all_assignments_f paf2
1261: where ppf.person_id = paf2.person_id
1262: and fnd_date.canonical_to_date(P_REPORT_DATE)
1263: between paf2.effective_start_date and paf2.effective_end_date
1264: )
1265: And pps.date_start = paf.effective_start_date
1266:

Line 1276: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)

1272: And paf.assignment_type = 'E'
1273: And paf.primary_flag = 'Y'
1274: And paf.location_id = hl.location_id
1275: And paf.job_id = job.job_id(+)
1276: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1277: and nvl(job.date_to, C_END_OF_TIME)
1278: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1279: And ppf.per_information_category = 'US'
1280: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1280: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

1276: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1277: and nvl(job.date_to, C_END_OF_TIME)
1278: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1279: And ppf.per_information_category = 'US'
1280: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)
1281: And ppf.per_information7 = 'INCL' And hou.business_group_id = ppf.business_group_id
1282: AND hoi1.organization_id = hou.organization_id
1283: AND hoi1.org_information_context = 'CLASS'
1284: AND hoi1.org_information1 = 'HR_LEGAL'

Line 1560: And fnd_date.canonical_to_date(P_REPORT_DATE)

1556: ,per_periods_of_service pps
1557:
1558: Where
1559: pps.person_id = ppf.person_id
1560: And fnd_date.canonical_to_date(P_REPORT_DATE)
1561: between pps.date_start and NVL(pps.actual_termination_date, C_END_OF_TIME)
1562: And fnd_date.canonical_to_date(P_REPORT_DATE)
1563: between ppf.effective_start_date and ppf.effective_end_date
1564: And ppf.person_id = paf.person_id

Line 1562: And fnd_date.canonical_to_date(P_REPORT_DATE)

1558: Where
1559: pps.person_id = ppf.person_id
1560: And fnd_date.canonical_to_date(P_REPORT_DATE)
1561: between pps.date_start and NVL(pps.actual_termination_date, C_END_OF_TIME)
1562: And fnd_date.canonical_to_date(P_REPORT_DATE)
1563: between ppf.effective_start_date and ppf.effective_end_date
1564: And ppf.person_id = paf.person_id
1565: And fnd_date.canonical_to_date(P_REPORT_DATE)
1566: between paf.effective_start_date and paf.effective_end_date

Line 1565: And fnd_date.canonical_to_date(P_REPORT_DATE)

1561: between pps.date_start and NVL(pps.actual_termination_date, C_END_OF_TIME)
1562: And fnd_date.canonical_to_date(P_REPORT_DATE)
1563: between ppf.effective_start_date and ppf.effective_end_date
1564: And ppf.person_id = paf.person_id
1565: And fnd_date.canonical_to_date(P_REPORT_DATE)
1566: between paf.effective_start_date and paf.effective_end_date
1567: And hscf.segment1 in
1568: (SELECT to_char(hou.organization_id )
1569: FROM hr_organization_units hou

Line 1581: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)

1577: or (P_STATE_CODE = 'FL' and P_MULTI_STATE_1 = 'Y')
1578: or (P_STATE_CODE <> 'FL')
1579: )
1580: And paf.job_id = job.job_id(+)
1581: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1582: and nvl(job.date_to, C_END_OF_TIME)
1583: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1584: And ppf.per_information_category = 'US'
1585: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1585: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

1581: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1582: and nvl(job.date_to, C_END_OF_TIME)
1583: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1584: And ppf.per_information_category = 'US'
1585: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)
1586: And ppf.per_information7 is NULL
1587: UNION
1588: select
1589: ppf.person_id

Line 1608: And fnd_date.canonical_to_date(P_REPORT_DATE)

1604:
1605: Where
1606: pps.person_id = ppf.person_id
1607:
1608: And fnd_date.canonical_to_date(P_REPORT_DATE)
1609: between ppf.effective_start_date and ppf.effective_end_date
1610: And ppf.person_id = paf.person_id
1611: And not exists (select 1 from per_all_assignments_f paf2
1612: where ppf.person_id = paf2.person_id

Line 1613: and fnd_date.canonical_to_date(P_REPORT_DATE)

1609: between ppf.effective_start_date and ppf.effective_end_date
1610: And ppf.person_id = paf.person_id
1611: And not exists (select 1 from per_all_assignments_f paf2
1612: where ppf.person_id = paf2.person_id
1613: and fnd_date.canonical_to_date(P_REPORT_DATE)
1614: between paf2.effective_start_date and paf2.effective_end_date
1615: )
1616: And pps.date_start = paf.effective_start_date
1617: And hscf.segment1 in

Line 1631: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)

1627: or (P_STATE_CODE = 'FL' and P_MULTI_STATE_1 = 'Y')
1628: or (P_STATE_CODE <> 'FL')
1629: )
1630: And paf.job_id = job.job_id(+)
1631: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1632: and nvl(job.date_to, C_END_OF_TIME)
1633: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1634: And ppf.per_information_category = 'US'
1635: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1635: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)

1631: And fnd_date.canonical_to_date(P_REPORT_DATE) between job.date_from(+)
1632: and nvl(job.date_to, C_END_OF_TIME)
1633: And ppf.business_group_id = P_BUSINESS_GROUP_ID
1634: And ppf.per_information_category = 'US'
1635: And ppf.start_date <= fnd_date.canonical_to_date(P_REPORT_DATE)
1636: And ppf.per_information7 is NULL
1637: Order by 2,3;
1638:
1639: