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

Line 62: and fnd_date.canonical_to_date(purt.organization_name) between paaf.effective_start_date

58: ,per_all_people_f papf
59: where purt.state_name = 'CARMILEAGE_UPGRADE'
60: and purt.tax_unit_id = 250
61: and paaf.assignment_id = purt.location_id
62: and fnd_date.canonical_to_date(purt.organization_name) between paaf.effective_start_date
63: and paaf.effective_end_date
64: and paaf.person_id = papf.person_id
65: and fnd_date.canonical_to_date(purt.organization_name) between papf.effective_start_date
66: and papf.effective_end_date;

Line 65: and fnd_date.canonical_to_date(purt.organization_name) between papf.effective_start_date

61: and paaf.assignment_id = purt.location_id
62: and fnd_date.canonical_to_date(purt.organization_name) between paaf.effective_start_date
63: and paaf.effective_end_date
64: and paaf.person_id = papf.person_id
65: and fnd_date.canonical_to_date(purt.organization_name) between papf.effective_start_date
66: and papf.effective_end_date;
67:
68:
69: l_ele_exst c_ele_exst%ROWTYPE;