DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_GENERAL

Line 183: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);

179: vXMLTable.DELETE;
180: vCtr := 1;
181: hr_utility.set_location('Entering report166 ',10);
182:
183: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
184:
185: vXMLTable(vCtr).TagName := 'R166-MONTH';
186: vXMLTable(vCtr).TagValue := l_effective_month;
187: vctr := vctr + 1;

Line 878: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);

874: OPEN csr_employer_name;
875: FETCH csr_employer_name INTO l_employer_name;
876: CLOSE csr_employer_name;
877:
878: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
879:
880: l_str1 := ''||''||''; /* Bug No : 8299900 */
881: l_str2 := ''||SUBSTR(l_employer_ssn,1,1)||'';
882: l_str3 := ''||SUBSTR(l_employer_ssn,2,1)||'';

Line 1388: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);

1384: OPEN csr_get_address;
1385: FETCH csr_get_address INTO l_emp_address;
1386: CLOSE csr_get_address;
1387:
1388: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
1389:
1390: l_str1 := ''||''||''; /* Bug No : 8299900 */
1391: /**************l_str2 := ''||SUBSTR(l_employer_ssn,1,1)||'';
1392: l_str3 := ''||SUBSTR(l_employer_ssn,2,1)||'';

Line 2032: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);

2028: vXMLTable.DELETE;
2029: vCtr := 1;
2030: hr_utility.set_location('Entering report168 ',10);
2031:
2032: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
2033:
2034: vXMLTable(vCtr).TagName := 'R168-MONTH';
2035: vXMLTable(vCtr).TagValue := l_effective_month;
2036: vctr := vctr + 1;