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

Line 1519: and fnd_date.canonical_to_date(ext.aei_information5) between

1515: and ext.aei_information3 is not null
1516: and ext.aei_information5 is not null
1517: and ext.aei_information6 is not null
1518: and ext.assignment_id = asg.assignment_id
1519: and fnd_date.canonical_to_date(ext.aei_information5) between
1520: asg.effective_start_date and asg.effective_end_date
1521: and asg.person_id = pen.person_id
1522: and to_number(ext.aei_information3) = pen.prtt_enrt_rslt_id
1523: and to_number(ext.aei_information6) = pen.pl_id

Line 1524: and fnd_date.canonical_to_date(ext.aei_information5) between

1520: asg.effective_start_date and asg.effective_end_date
1521: and asg.person_id = pen.person_id
1522: and to_number(ext.aei_information3) = pen.prtt_enrt_rslt_id
1523: and to_number(ext.aei_information6) = pen.pl_id
1524: and fnd_date.canonical_to_date(ext.aei_information5) between
1525: pen.effective_start_date and pen.effective_end_date
1526: and pen.per_in_ler_id is not null;
1527:
1528: cursor c_epe_rsgn_appr is