APPS.PAY_NL_ATS_REPORT dependencies on FND_DATE

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

290: l_Applied_LCLD:=0;
291: vUserBalVal.DELETE;
292: l_previous_person_id:=-1;
293:
294: l_effective_date := fnd_date.canonical_to_date(p_year);
295: l_year := to_char(l_effective_date,'YYYY');
296: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');

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

862: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
863: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
864: vCtr := vCtr + 1;
865:
866: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
867: FETCH csr_emp_glb_address
868: INTO l_house_number_ee,
869: l_house_add_no_ee,
870: l_street_name_ee,

Line 883: ,fnd_date.canonical_to_date(p_year)

879:
880: IF l_add_style_ee = 'NL' THEN
881:
882: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
883: ,fnd_date.canonical_to_date(p_year)
884: ,l_house_number_ee
885: ,l_house_add_no_ee
886: ,l_street_name_ee
887: ,l_line1_ee

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

1223: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
1224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
1225: vCtr := vCtr + 1;
1226:
1227: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
1228: FETCH csr_emp_glb_address
1229: INTO l_house_number_ee,
1230: l_house_add_no_ee,
1231: l_street_name_ee,

Line 1244: ,fnd_date.canonical_to_date(p_year)

1240:
1241: IF l_add_style_ee = 'NL' THEN
1242:
1243: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
1244: ,fnd_date.canonical_to_date(p_year)
1245: ,l_house_number_ee
1246: ,l_house_add_no_ee
1247: ,l_street_name_ee
1248: ,l_line1_ee

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

1918: l_Applied_LCLD:=0;
1919: vUserBalVal.DELETE;
1920: l_previous_person_id:=-1;
1921:
1922: l_effective_date := fnd_date.canonical_to_date(p_year);
1923: l_year := to_char(l_effective_date,'YYYY');
1924: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');

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

2490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
2491: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
2492: vCtr := vCtr + 1;
2493:
2494: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
2495: FETCH csr_emp_glb_address
2496: INTO l_house_number_ee,
2497: l_house_add_no_ee,
2498: l_street_name_ee,

Line 2511: ,fnd_date.canonical_to_date(p_year)

2507:
2508: IF l_add_style_ee = 'NL' THEN
2509:
2510: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2511: ,fnd_date.canonical_to_date(p_year)
2512: ,l_house_number_ee
2513: ,l_house_add_no_ee
2514: ,l_street_name_ee
2515: ,l_line1_ee

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

2851: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Employee_Name';
2852: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Employee_Name;
2853: vCtr := vCtr + 1;
2854:
2855: OPEN csr_emp_glb_address(l_person_id, fnd_date.canonical_to_date(p_year));
2856: FETCH csr_emp_glb_address
2857: INTO l_house_number_ee,
2858: l_house_add_no_ee,
2859: l_street_name_ee,

Line 2872: ,fnd_date.canonical_to_date(p_year)

2868:
2869: IF l_add_style_ee = 'NL' THEN
2870:
2871: l_return_value1 := pay_nl_general.get_emp_address(l_person_id
2872: ,fnd_date.canonical_to_date(p_year)
2873: ,l_house_number_ee
2874: ,l_house_add_no_ee
2875: ,l_street_name_ee
2876: ,l_line1_ee