APPS.PAY_IE_EHECS_REPORT_PKG dependencies on FND_DATE

Line 952: --g_start_date := fnd_date.canonical_to_date(l_start_date);

948: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
951:
952: --g_start_date := fnd_date.canonical_to_date(l_start_date);
953: --g_end_date := fnd_date.canonical_to_date(l_end_date);
954:
955: -- g_pact_id := pactid;
956:

Line 953: --g_end_date := fnd_date.canonical_to_date(l_end_date);

949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
951:
952: --g_start_date := fnd_date.canonical_to_date(l_start_date);
953: --g_end_date := fnd_date.canonical_to_date(l_end_date);
954:
955: -- g_pact_id := pactid;
956:
957: --hr_utility.set_location('after get_all_parameter called',225);

Line 2168: l_string := l_string || ' '|| to_char(fnd_date.canonical_to_date(l_header.declare_date),'DDMMYYYY') ||''; /* 7367314QA */

2164: l_string := l_string || ' '|| substr(l_header.declarant_name,1,40) ||'';
2165: l_string := l_string || ' '|| substr(l_header.declarant_phone,1,14) ||'' ;
2166: l_string := l_string || ' '|| substr(l_header.declarant_email,1,80) ||'';
2167: --l_string := l_string || ' '|| l_header.declare_date ||'';
2168: l_string := l_string || ' '|| to_char(fnd_date.canonical_to_date(l_header.declare_date),'DDMMYYYY') ||''; /* 7367314QA */
2169: l_string := l_string || ' '||l_header.declarant_position||'';
2170:
2171: l_string := l_string ||''||EOL ;
2172: l_clob := l_clob||l_string;

Line 2404: and fnd_date.canonical_to_date(hoi.org_information13) between g_qtr_start_date and g_qtr_end_date

2400: and hoi.org_information1 IS NOT NULL
2401: and hoi.org_information2 IS NOT NULL
2402: --and decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P') = NVL(g_occupational_category_M_C_P,decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P'))
2403: and decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') = NVL(g_occupational_category_M_C_P,decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P'))
2404: and fnd_date.canonical_to_date(hoi.org_information13) between g_qtr_start_date and g_qtr_end_date
2405: --group by decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P'),
2406: group by decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P'),
2407: decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2)
2408: )