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

Line 359: fnd_date.canonical_to_date(pae.aei_information1)

355: pae.AEI_INFORMATION3 = DECODE(l_si_type,'WEWA','AMI','WEWE','AMI','WAOD','AMI','WAOB','AMI',
356: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
357: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
358: and s.effective_date between
359: fnd_date.canonical_to_date(pae.aei_information1)
360: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND
361: s.session_id=userenv('sessionid')
362: order by si_class_order desc;
363:

Line 360: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND

356: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
357: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
358: and s.effective_date between
359: fnd_date.canonical_to_date(pae.aei_information1)
360: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND
361: s.session_id=userenv('sessionid')
362: order by si_class_order desc;
363:
364: --

Line 390: fnd_date.canonical_to_date(e.org_INFORMATION1)

386: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
387: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type)) and
388: e.org_information4 = NVL(l_uwv_id,e.org_information4)
389: and s.effective_date between
390: fnd_date.canonical_to_date(e.org_INFORMATION1)
391: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND
392: s.session_id=userenv('sessionid')
393: order by p_flag desc,si_class_order desc;
394:

Line 391: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND

387: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type)) and
388: e.org_information4 = NVL(l_uwv_id,e.org_information4)
389: and s.effective_date between
390: fnd_date.canonical_to_date(e.org_INFORMATION1)
391: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND
392: s.session_id=userenv('sessionid')
393: order by p_flag desc,si_class_order desc;
394:
395: v_asg_provider asg_provider%ROWTYPE;

Line 504: fnd_date.canonical_to_date(pae.aei_information1)

500: 'WAOB','AMI','WAOD','AMI',
501: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
502: 'ZVW','AMI','ZVWL','AMI','ZVWS','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
503: and s.effective_date between
504: fnd_date.canonical_to_date(pae.aei_information1)
505: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND
506: s.session_id=userenv('sessionid')
507: order by si_class_order desc;
508:

Line 505: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND

501: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
502: 'ZVW','AMI','ZVWL','AMI','ZVWS','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
503: and s.effective_date between
504: fnd_date.canonical_to_date(pae.aei_information1)
505: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND
506: s.session_id=userenv('sessionid')
507: order by si_class_order desc;
508:
509: --

Line 531: fnd_date.canonical_to_date(e.org_INFORMATION1)

527: e.org_information3 = DECODE(l_si_type,'WEWE','AMI','WEWA','AMI','WAOB','AMI','WAOD','AMI',
528: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
529: 'ZVW','AMI','ZVWL','AMI','ZVWS','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type)) and
530: s.effective_date between
531: fnd_date.canonical_to_date(e.org_INFORMATION1)
532: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND
533: s.session_id=userenv('sessionid')
534: order by p_flag desc,si_class_order desc;
535:

Line 532: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND

528: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
529: 'ZVW','AMI','ZVWL','AMI','ZVWS','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type)) and
530: s.effective_date between
531: fnd_date.canonical_to_date(e.org_INFORMATION1)
532: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND
533: s.session_id=userenv('sessionid')
534: order by p_flag desc,si_class_order desc;
535:
536: v_asg_provider asg_provider%ROWTYPE;

Line 733: fnd_date.canonical_to_date(pae.aei_information1)

729: pae.AEI_INFORMATION3 = DECODE(l_si_type,'WEWA','AMI','WEWE','AMI','WAOD','AMI','WAOB','AMI',
730: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
731: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
732: and s.effective_date between
733: fnd_date.canonical_to_date(pae.aei_information1)
734: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date)
735: and session_id = userenv('sessionid')
736: order by si_class_order desc;
737: v_asg_provider asg_provider%ROWTYPE;

Line 734: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date)

730: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
731: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
732: and s.effective_date between
733: fnd_date.canonical_to_date(pae.aei_information1)
734: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date)
735: and session_id = userenv('sessionid')
736: order by si_class_order desc;
737: v_asg_provider asg_provider%ROWTYPE;
738: BEGIN

Line 1345: fnd_date.canonical_to_date(pae.aei_information1)

1341: 'WAOB','AMI','WAOD','AMI',
1342: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
1343: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
1344: and s.effective_date between
1345: fnd_date.canonical_to_date(pae.aei_information1)
1346: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND
1347: s.session_id=userenv('sessionid')
1348: order by si_class_order desc;
1349:

Line 1346: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND

1342: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
1343: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type))
1344: and s.effective_date between
1345: fnd_date.canonical_to_date(pae.aei_information1)
1346: and nvl(fnd_date.canonical_to_date(pae.aei_information2),s.effective_date) AND
1347: s.session_id=userenv('sessionid')
1348: order by si_class_order desc;
1349:
1350: --

Line 1372: fnd_date.canonical_to_date(e.org_INFORMATION1)

1368: e.org_information3 = DECODE(l_si_type,'WEWE','AMI','WEWA','AMI','WAOB','AMI','WAOD','AMI',
1369: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
1370: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type)) and
1371: s.effective_date between
1372: fnd_date.canonical_to_date(e.org_INFORMATION1)
1373: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND
1374: s.session_id=userenv('sessionid')
1375: order by p_flag desc,si_class_order desc;
1376:

Line 1373: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND

1369: 'ZFW','AMI','PRIVATE_HEALTH','AMI','ZW','AMI',
1370: 'ZVW','AMI','WGA','AMI','IVA','AMI','UFO','AMI',l_si_type)) and
1371: s.effective_date between
1372: fnd_date.canonical_to_date(e.org_INFORMATION1)
1373: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),s.effective_date) AND
1374: s.session_id=userenv('sessionid')
1375: order by p_flag desc,si_class_order desc;
1376:
1377: v_asg_provider asg_provider%ROWTYPE;

Line 2247: and l_date_earned between fnd_date.canonical_to_date(e.org_INFORMATION1)

2243: hr_organization_information e
2244: where e.organization_id=l_org_id
2245: and e.org_information_context = 'NL_AMI'
2246: and e.org_information3=l_si_class
2247: and l_date_earned between fnd_date.canonical_to_date(e.org_INFORMATION1)
2248: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),hr_general.END_OF_TIME);
2249:
2250: v_org_si_excluded org_si_excluded%ROWTYPE;
2251: l_level number;

Line 2248: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),hr_general.END_OF_TIME);

2244: where e.organization_id=l_org_id
2245: and e.org_information_context = 'NL_AMI'
2246: and e.org_information3=l_si_class
2247: and l_date_earned between fnd_date.canonical_to_date(e.org_INFORMATION1)
2248: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),hr_general.END_OF_TIME);
2249:
2250: v_org_si_excluded org_si_excluded%ROWTYPE;
2251: l_level number;
2252: l_organization_id hr_organization_units.organization_id%TYPE;