APPS.PAY_NL_ATS_REPORT dependencies on FND_DATE

Line 278: l_effective_date := fnd_date.canonical_to_date(p_year);

274: l_Applied_LCLD:=0;
275: vUserBalVal.DELETE;
276: l_previous_person_id:=-1;
277:
278: l_effective_date := fnd_date.canonical_to_date(p_year);
279: l_year := to_char(l_effective_date,'YYYY');
280: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
281: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
282: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');

Line 845: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));

841: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
842: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
843: vCtr := vCtr + 1;
844:
845: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
846: FETCH csr_emp_glb_address
847: INTO l_house_number_ee,
848: l_house_add_no_ee,
849: l_street_name_ee,

Line 862: ,fnd_date.canonical_to_date(p_year)

858:
859: IF l_add_style_ee = 'NL' THEN
860:
861: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
862: ,fnd_date.canonical_to_date(p_year)
863: ,l_house_number_ee
864: ,l_house_add_no_ee
865: ,l_street_name_ee
866: ,l_line1_ee

Line 1206: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));

1202: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
1204: vCtr := vCtr + 1;
1205:
1206: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
1207: FETCH csr_emp_glb_address
1208: INTO l_house_number_ee,
1209: l_house_add_no_ee,
1210: l_street_name_ee,

Line 1223: ,fnd_date.canonical_to_date(p_year)

1219:
1220: IF l_add_style_ee = 'NL' THEN
1221:
1222: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
1223: ,fnd_date.canonical_to_date(p_year)
1224: ,l_house_number_ee
1225: ,l_house_add_no_ee
1226: ,l_street_name_ee
1227: ,l_line1_ee

Line 1875: l_effective_date := fnd_date.canonical_to_date(p_year);

1871: l_Applied_LCLD:=0;
1872: vUserBalVal.DELETE;
1873: l_previous_person_id:=-1;
1874:
1875: l_effective_date := fnd_date.canonical_to_date(p_year);
1876: l_year := to_char(l_effective_date,'YYYY');
1877: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1878: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1879: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');

Line 2442: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));

2438: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
2439: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
2440: vCtr := vCtr + 1;
2441:
2442: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
2443: FETCH csr_emp_glb_address
2444: INTO l_house_number_ee,
2445: l_house_add_no_ee,
2446: l_street_name_ee,

Line 2459: ,fnd_date.canonical_to_date(p_year)

2455:
2456: IF l_add_style_ee = 'NL' THEN
2457:
2458: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2459: ,fnd_date.canonical_to_date(p_year)
2460: ,l_house_number_ee
2461: ,l_house_add_no_ee
2462: ,l_street_name_ee
2463: ,l_line1_ee

Line 2803: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));

2799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
2800: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
2801: vCtr := vCtr + 1;
2802:
2803: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
2804: FETCH csr_emp_glb_address
2805: INTO l_house_number_ee,
2806: l_house_add_no_ee,
2807: l_street_name_ee,

Line 2820: ,fnd_date.canonical_to_date(p_year)

2816:
2817: IF l_add_style_ee = 'NL' THEN
2818:
2819: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2820: ,fnd_date.canonical_to_date(p_year)
2821: ,l_house_number_ee
2822: ,l_house_add_no_ee
2823: ,l_street_name_ee
2824: ,l_line1_ee