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 112: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

108: L_CONTACT_TITLE VARCHAR2(160);
109: L_CONTACT_PHONE VARCHAR2(60);
110: BEGIN
111: L_PERSON_ID := NEW_HIRE_CONTACT_ID;
112: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
113: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
114: PER_NEW_HIRE_PKG.GET_NEW_HIRE_CONTACT(L_PERSON_ID
115: ,L_BUSINESS_GROUP_ID
116: ,L_REPORT_DATE

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

140: SET_LOCATION('Entered c_salary formula'
141: ,5);
142: IF P_STATE_CODE = 'TX' OR P_STATE_CODE = 'OR' OR P_STATE_CODE = 'MD' THEN
143: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
144: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
145: L_SALARY := GET_SALARY(L_BUSINESS_GROUP_ID
146: ,ASSIGNMENT_ID
147: ,L_REPORT_DATE);
148: SET_LOCATION('Leaving c_salary formula'

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

237: HR_LOCATIONS_ALL HL,
238: PER_JOBS JOB,
239: PER_PERIODS_OF_SERVICE PPS
240: WHERE PPS.PERSON_ID = PPF.PERSON_ID
241: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
242: AND NVL(PPS.ACTUAL_TERMINATION_DATE
243: ,C_END_OF_TIME)
244: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
245: AND PPF.EFFECTIVE_END_DATE

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

240: WHERE PPS.PERSON_ID = PPF.PERSON_ID
241: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
242: AND NVL(PPS.ACTUAL_TERMINATION_DATE
243: ,C_END_OF_TIME)
244: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
245: AND PPF.EFFECTIVE_END_DATE
246: AND PPF.PERSON_ID = PAF.PERSON_ID
247: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
248: AND PAF.EFFECTIVE_END_DATE

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

243: ,C_END_OF_TIME)
244: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
245: AND PPF.EFFECTIVE_END_DATE
246: AND PPF.PERSON_ID = PAF.PERSON_ID
247: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
248: AND PAF.EFFECTIVE_END_DATE
249: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)
250: AND PAF.SOFT_CODING_KEYFLEX_ID = HSCF.SOFT_CODING_KEYFLEX_ID
251: AND PAF.ASSIGNMENT_TYPE = 'E'

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

253: AND PAF.LOCATION_ID = HL.LOCATION_ID
254: AND HL.REGION_2 = NVL(P_STATE_CODE
255: ,HL.REGION_2)
256: AND PAF.JOB_ID = job.job_id (+)
257: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
258: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
259: AND NVL(JOB.DATE_TO
260: ,C_END_OF_TIME)
261: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 258: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

254: AND HL.REGION_2 = NVL(P_STATE_CODE
255: ,HL.REGION_2)
256: AND PAF.JOB_ID = job.job_id (+)
257: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
258: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
259: AND NVL(JOB.DATE_TO
260: ,C_END_OF_TIME)
261: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
262: AND PPF.PER_INFORMATION_CATEGORY = 'US'

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

259: AND NVL(JOB.DATE_TO
260: ,C_END_OF_TIME)
261: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
262: AND PPF.PER_INFORMATION_CATEGORY = 'US'
263: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
264: --AND PPF.PER_INFORMATION7 = 'INCL'
265: AND PPF.PER_INFORMATION7 IN ('INCL','INCLWH') --bug 14532612
266: UNION
267: SELECT

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

275: HR_LOCATIONS_ALL HL,
276: PER_JOBS JOB,
277: PER_PERIODS_OF_SERVICE PPS
278: WHERE PPS.PERSON_ID = PPF.PERSON_ID
279: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
280: AND PPF.EFFECTIVE_END_DATE
281: AND PPS.ACTUAL_TERMINATION_DATE IS NOT NULL
282: AND PPF.PERSON_ID = PAF.PERSON_ID
283: AND not exists (

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

285: 1
286: FROM
287: PER_PERIODS_OF_SERVICE PPS2
288: WHERE PPF.PERSON_ID = PPS2.PERSON_ID
289: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START
290: AND NVL(PPS2.ACTUAL_TERMINATION_DATE
291: ,C_END_OF_TIME) )
292: AND PPS.DATE_START = PAF.EFFECTIVE_START_DATE
293: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)

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

297: AND PAF.LOCATION_ID = HL.LOCATION_ID
298: AND HL.REGION_2 = NVL(P_STATE_CODE
299: ,HL.REGION_2)
300: AND PAF.JOB_ID = job.job_id (+)
301: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
302: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
303: AND NVL(JOB.DATE_TO
304: ,C_END_OF_TIME)
305: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 302: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

298: AND HL.REGION_2 = NVL(P_STATE_CODE
299: ,HL.REGION_2)
300: AND PAF.JOB_ID = job.job_id (+)
301: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
302: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
303: AND NVL(JOB.DATE_TO
304: ,C_END_OF_TIME)
305: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
306: AND PPF.PER_INFORMATION_CATEGORY = 'US'

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

303: AND NVL(JOB.DATE_TO
304: ,C_END_OF_TIME)
305: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
306: AND PPF.PER_INFORMATION_CATEGORY = 'US'
307: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
308: --AND PPF.PER_INFORMATION7 = 'INCL'
309: AND PPF.PER_INFORMATION7 IN ('INCL','INCLWH') --bug 14532612
310: ORDER BY
311: 2,

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

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

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

392: L_CONTACT_TITLE VARCHAR2(160);
393: L_CONTACT_PHONE VARCHAR2(60);
394: BEGIN
395: L_PERSON_ID := NEW_HIRE_CONTACT_ID;
396: L_REPORT_DATE := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
397: L_BUSINESS_GROUP_ID := P_BUSINESS_GROUP_ID;
398: PER_NEW_HIRE_PKG.GET_NEW_HIRE_CONTACT(L_PERSON_ID
399: ,L_BUSINESS_GROUP_ID
400: ,L_REPORT_DATE

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

442: HR_LOCATIONS_ALL HL,
443: PER_JOBS JOB,
444: PER_PERIODS_OF_SERVICE PPS
445: WHERE PPS.PERSON_ID = PPF.PERSON_ID
446: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
447: AND NVL(PPS.ACTUAL_TERMINATION_DATE
448: ,C_END_OF_TIME)
449: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
450: AND PPF.EFFECTIVE_END_DATE

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

445: WHERE PPS.PERSON_ID = PPF.PERSON_ID
446: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS.DATE_START
447: AND NVL(PPS.ACTUAL_TERMINATION_DATE
448: ,C_END_OF_TIME)
449: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
450: AND PPF.EFFECTIVE_END_DATE
451: AND PPF.PERSON_ID = PAF.PERSON_ID
452: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
453: AND PAF.EFFECTIVE_END_DATE

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

448: ,C_END_OF_TIME)
449: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
450: AND PPF.EFFECTIVE_END_DATE
451: AND PPF.PERSON_ID = PAF.PERSON_ID
452: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PAF.EFFECTIVE_START_DATE
453: AND PAF.EFFECTIVE_END_DATE
454: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)
455: AND PAF.SOFT_CODING_KEYFLEX_ID = HSCF.SOFT_CODING_KEYFLEX_ID
456: AND PAF.ASSIGNMENT_TYPE = 'E'

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

458: AND PAF.LOCATION_ID = HL.LOCATION_ID
459: AND HL.REGION_2 = NVL(P_STATE_CODE
460: ,HL.REGION_2)
461: AND PAF.JOB_ID = job.job_id (+)
462: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
463: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
464: AND NVL(JOB.DATE_TO
465: ,C_END_OF_TIME)
466: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 463: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

459: AND HL.REGION_2 = NVL(P_STATE_CODE
460: ,HL.REGION_2)
461: AND PAF.JOB_ID = job.job_id (+)
462: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
463: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
464: AND NVL(JOB.DATE_TO
465: ,C_END_OF_TIME)
466: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
467: AND PPF.PER_INFORMATION_CATEGORY = 'US'

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

464: AND NVL(JOB.DATE_TO
465: ,C_END_OF_TIME)
466: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
467: AND PPF.PER_INFORMATION_CATEGORY = 'US'
468: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
469: AND PPF.PER_INFORMATION7 is NULL
470: UNION
471: SELECT
472: PPF.PERSON_ID,

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

485: HR_LOCATIONS_ALL HL,
486: PER_JOBS JOB,
487: PER_PERIODS_OF_SERVICE PPS
488: WHERE PPS.PERSON_ID = PPF.PERSON_ID
489: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPF.EFFECTIVE_START_DATE
490: AND PPF.EFFECTIVE_END_DATE
491: AND PPS.ACTUAL_TERMINATION_DATE IS NOT NULL
492: AND PPF.PERSON_ID = PAF.PERSON_ID
493: AND not exists (

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

495: 1
496: FROM
497: PER_PERIODS_OF_SERVICE PPS2
498: WHERE PPF.PERSON_ID = PPS2.PERSON_ID
499: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between PPS2.DATE_START
500: AND NVL(PPS2.ACTUAL_TERMINATION_DATE
501: ,C_END_OF_TIME) )
502: AND PPS.DATE_START = PAF.EFFECTIVE_START_DATE
503: AND HSCF.SEGMENT1 = TO_CHAR(P_TAX_UNIT_ID)

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

507: AND PAF.LOCATION_ID = HL.LOCATION_ID
508: AND HL.REGION_2 = NVL(P_STATE_CODE
509: ,HL.REGION_2)
510: AND PAF.JOB_ID = job.job_id (+)
511: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
512: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
513: AND NVL(JOB.DATE_TO
514: ,C_END_OF_TIME)
515: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 512: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))

508: AND HL.REGION_2 = NVL(P_STATE_CODE
509: ,HL.REGION_2)
510: AND PAF.JOB_ID = job.job_id (+)
511: AND FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE) between NVL(JOB.DATE_FROM
512: ,FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE))
513: AND NVL(JOB.DATE_TO
514: ,C_END_OF_TIME)
515: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
516: AND PPF.PER_INFORMATION_CATEGORY = 'US'

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

513: AND NVL(JOB.DATE_TO
514: ,C_END_OF_TIME)
515: AND PPF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
516: AND PPF.PER_INFORMATION_CATEGORY = 'US'
517: AND PPS.DATE_START <= FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE)
518: AND PPF.PER_INFORMATION7 is NULL
519: ORDER BY
520: 2,
521: 3;