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

Line 53: l_report_date := fnd_date.canonical_to_date(p_report_date); --to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS');

49: l_pt VARCHAR2(2000);
50: begin
51:
52: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);
53: l_report_date := fnd_date.canonical_to_date(p_report_date); --to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS');
54: pqh_employment_category.fetch_empl_categories(p_business_group_id
55: ,l_fr
56: ,l_ft
57: ,l_pr

Line 75: AND fnd_date.date_to_canonical(''' || to_char(l_report_date) || ''') between pei.pei_information7 and pei.pei_information8

71: WHERE peo.person_id = ass.person_id
72: AND NOT EXISTS (SELECT 1 FROM per_people_extra_info pei
73: WHERE peo.person_id = pei.person_id
74: AND pei.information_type = ''PER_US_VISA_DETAILS''
75: AND fnd_date.date_to_canonical(''' || to_char(l_report_date) || ''') between pei.pei_information7 and pei.pei_information8
76: AND pei.pei_information9 IN (''04'',''05'',''06'',''07'',''12''))
77: AND peo.current_employee_flag = ''Y''
78: AND hl.lookup_code = job.job_information8
79: AND pqh_employment_category.identify_empl_category(ass.employment_category,