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_PERUSHIR_XMLP_PKG dependencies on FND_DATE

Line 82: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

78: L_CONTACT_TITLE VARCHAR2(160);
79: L_CONTACT_PHONE VARCHAR2(60);
80: BEGIN
81: L_PERSON_ID := NEW_HIRE_CONTACT_ID;
82: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
83: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
84: PER_NEW_HIRE_PKG.GET_NEW_HIRE_CONTACT(L_PERSON_ID
85: ,L_BUSINESS_GROUP_ID
86: ,L_REPORT_DATE

Line 114: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

110: SET_LOCATION('Entered c_salary formula'
111: ,5);
112: IF P_STATE_CODE = 'TX' OR P_STATE_CODE = 'OR' OR P_STATE_CODE = 'MD' THEN
113: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
114: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
115: L_SALARY := GET_SALARY(L_BUSINESS_GROUP_ID
116: ,ASSIGNMENT_ID
117: ,L_REPORT_DATE);
118: SET_LOCATION('Leaving c_salary formula'

Line 212: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START

208: HR_LOCATIONS_ALL HL,
209: PER_JOBS JOB,
210: PER_PERIODS_OF_SERVICE PPS
211: WHERE PPS.PERSON_ID = PPF.PERSON_ID
212: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
213: AND NVL(PPS.ACTUAL_TERMINATION_DATE
214: ,C_END_OF_TIME)
215: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
216: AND PPF.EFFECTIVE_END_DATE

Line 215: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE

211: WHERE PPS.PERSON_ID = PPF.PERSON_ID
212: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
213: AND NVL(PPS.ACTUAL_TERMINATION_DATE
214: ,C_END_OF_TIME)
215: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
216: AND PPF.EFFECTIVE_END_DATE
217: AND PPF.PERSON_ID = PAF.PERSON_ID
218: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
219: AND PAF.EFFECTIVE_END_DATE

Line 218: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE

214: ,C_END_OF_TIME)
215: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
216: AND PPF.EFFECTIVE_END_DATE
217: AND PPF.PERSON_ID = PAF.PERSON_ID
218: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
219: AND PAF.EFFECTIVE_END_DATE
220: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)
221: AND PAF.SOFT_CODING_KEYFLEX_ID = HSCF.SOFT_CODING_KEYFLEX_ID
222: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 228: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM

224: AND PAF.LOCATION_ID = HL.LOCATION_ID
225: AND HL.REGION_2 = NVL(P_STATE_CODE
226: ,HL.REGION_2)
227: AND PAF.JOB_ID = job.job_id (+)
228: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
229: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
230: AND NVL(JOB.DATE_TO
231: ,C_END_OF_TIME)
232: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 229: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

225: AND HL.REGION_2 = NVL(P_STATE_CODE
226: ,HL.REGION_2)
227: AND PAF.JOB_ID = job.job_id (+)
228: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
229: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
230: AND NVL(JOB.DATE_TO
231: ,C_END_OF_TIME)
232: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
233: AND PPF.PER_INFORMATION_CATEGORY = 'US'

Line 234: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)

230: AND NVL(JOB.DATE_TO
231: ,C_END_OF_TIME)
232: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
233: AND PPF.PER_INFORMATION_CATEGORY = 'US'
234: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
235: AND PPF.PER_INFORMATION7 = 'INCL'
236: UNION
237: SELECT
238: PPF.PERSON_ID,

Line 249: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE

245: HR_LOCATIONS_ALL HL,
246: PER_JOBS JOB,
247: PER_PERIODS_OF_SERVICE PPS
248: WHERE PPS.PERSON_ID = PPF.PERSON_ID
249: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
250: AND PPF.EFFECTIVE_END_DATE
251: AND PPS.ACTUAL_TERMINATION_DATE IS NOT NULL
252: AND PPF.PERSON_ID = PAF.PERSON_ID
253: AND not exists (

Line 259: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START

255: 1
256: FROM
257: PER_PERIODS_OF_SERVICE PPS2
258: WHERE PPF.PERSON_ID = PPS2.PERSON_ID
259: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START
260: AND NVL(PPS2.ACTUAL_TERMINATION_DATE
261: ,C_END_OF_TIME) )
262: AND PPS.DATE_START = PAF.EFFECTIVE_START_DATE
263: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)

Line 271: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM

267: AND PAF.LOCATION_ID = HL.LOCATION_ID
268: AND HL.REGION_2 = NVL(P_STATE_CODE
269: ,HL.REGION_2)
270: AND PAF.JOB_ID = job.job_id (+)
271: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
272: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
273: AND NVL(JOB.DATE_TO
274: ,C_END_OF_TIME)
275: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 272: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

268: AND HL.REGION_2 = NVL(P_STATE_CODE
269: ,HL.REGION_2)
270: AND PAF.JOB_ID = job.job_id (+)
271: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
272: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
273: AND NVL(JOB.DATE_TO
274: ,C_END_OF_TIME)
275: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
276: AND PPF.PER_INFORMATION_CATEGORY = 'US'

Line 277: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)

273: AND NVL(JOB.DATE_TO
274: ,C_END_OF_TIME)
275: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
276: AND PPF.PER_INFORMATION_CATEGORY = 'US'
277: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
278: AND PPF.PER_INFORMATION7 = 'INCL'
279: ORDER BY
280: 2,
281: 3;

Line 333: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

329: L_CONTACT_TITLE VARCHAR2(160);
330: L_CONTACT_PHONE VARCHAR2(60);
331: BEGIN
332: L_PERSON_ID := NEW_HIRE_CONTACT_ID;
333: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
334: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
335: PER_NEW_HIRE_PKG.GET_NEW_HIRE_CONTACT(L_PERSON_ID
336: ,L_BUSINESS_GROUP_ID
337: ,L_REPORT_DATE

Line 365: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

361: L_CONTACT_TITLE VARCHAR2(160);
362: L_CONTACT_PHONE VARCHAR2(60);
363: BEGIN
364: L_PERSON_ID := NEW_HIRE_CONTACT_ID;
365: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
366: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
367: PER_NEW_HIRE_PKG.GET_NEW_HIRE_CONTACT(L_PERSON_ID
368: ,L_BUSINESS_GROUP_ID
369: ,L_REPORT_DATE

Line 415: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START

411: HR_LOCATIONS_ALL HL,
412: PER_JOBS JOB,
413: PER_PERIODS_OF_SERVICE PPS
414: WHERE PPS.PERSON_ID = PPF.PERSON_ID
415: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
416: AND NVL(PPS.ACTUAL_TERMINATION_DATE
417: ,C_END_OF_TIME)
418: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
419: AND PPF.EFFECTIVE_END_DATE

Line 418: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE

414: WHERE PPS.PERSON_ID = PPF.PERSON_ID
415: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
416: AND NVL(PPS.ACTUAL_TERMINATION_DATE
417: ,C_END_OF_TIME)
418: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
419: AND PPF.EFFECTIVE_END_DATE
420: AND PPF.PERSON_ID = PAF.PERSON_ID
421: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
422: AND PAF.EFFECTIVE_END_DATE

Line 421: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE

417: ,C_END_OF_TIME)
418: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
419: AND PPF.EFFECTIVE_END_DATE
420: AND PPF.PERSON_ID = PAF.PERSON_ID
421: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
422: AND PAF.EFFECTIVE_END_DATE
423: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)
424: AND PAF.SOFT_CODING_KEYFLEX_ID = HSCF.SOFT_CODING_KEYFLEX_ID
425: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 431: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM

427: AND PAF.LOCATION_ID = HL.LOCATION_ID
428: AND HL.REGION_2 = NVL(P_STATE_CODE
429: ,HL.REGION_2)
430: AND PAF.JOB_ID = job.job_id (+)
431: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
432: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
433: AND NVL(JOB.DATE_TO
434: ,C_END_OF_TIME)
435: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 432: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

428: AND HL.REGION_2 = NVL(P_STATE_CODE
429: ,HL.REGION_2)
430: AND PAF.JOB_ID = job.job_id (+)
431: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
432: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
433: AND NVL(JOB.DATE_TO
434: ,C_END_OF_TIME)
435: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
436: AND PPF.PER_INFORMATION_CATEGORY = 'US'

Line 437: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)

433: AND NVL(JOB.DATE_TO
434: ,C_END_OF_TIME)
435: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
436: AND PPF.PER_INFORMATION_CATEGORY = 'US'
437: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
438: AND PPF.PER_INFORMATION7 is NULL
439: UNION
440: SELECT
441: PPF.PERSON_ID,

Line 458: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE

454: HR_LOCATIONS_ALL HL,
455: PER_JOBS JOB,
456: PER_PERIODS_OF_SERVICE PPS
457: WHERE PPS.PERSON_ID = PPF.PERSON_ID
458: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
459: AND PPF.EFFECTIVE_END_DATE
460: AND PPS.ACTUAL_TERMINATION_DATE IS NOT NULL
461: AND PPF.PERSON_ID = PAF.PERSON_ID
462: AND not exists (

Line 468: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START

464: 1
465: FROM
466: PER_PERIODS_OF_SERVICE PPS2
467: WHERE PPF.PERSON_ID = PPS2.PERSON_ID
468: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START
469: AND NVL(PPS2.ACTUAL_TERMINATION_DATE
470: ,C_END_OF_TIME) )
471: AND PPS.DATE_START = PAF.EFFECTIVE_START_DATE
472: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)

Line 480: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM

476: AND PAF.LOCATION_ID = HL.LOCATION_ID
477: AND HL.REGION_2 = NVL(P_STATE_CODE
478: ,HL.REGION_2)
479: AND PAF.JOB_ID = job.job_id (+)
480: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
481: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
482: AND NVL(JOB.DATE_TO
483: ,C_END_OF_TIME)
484: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 481: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

477: AND HL.REGION_2 = NVL(P_STATE_CODE
478: ,HL.REGION_2)
479: AND PAF.JOB_ID = job.job_id (+)
480: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
481: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
482: AND NVL(JOB.DATE_TO
483: ,C_END_OF_TIME)
484: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
485: AND PPF.PER_INFORMATION_CATEGORY = 'US'

Line 486: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)

482: AND NVL(JOB.DATE_TO
483: ,C_END_OF_TIME)
484: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
485: AND PPF.PER_INFORMATION_CATEGORY = 'US'
486: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
487: AND PPF.PER_INFORMATION7 is NULL
488: ORDER BY
489: 2,
490: 3;