DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_GENERAL

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

152: vXMLTable.DELETE;
153: vCtr := 1;
154: hr_utility.set_location('Entering report166 ',10);
155:
156: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
157:
158: vXMLTable(vCtr).TagName := 'R166-MONTH';
159: vXMLTable(vCtr).TagValue := l_effective_month;
160: vctr := vctr + 1;

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

723: OPEN csr_employer_name;
724: FETCH csr_employer_name INTO l_employer_name;
725: CLOSE csr_employer_name;
726:
727: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
728:
729: l_str1 := ''||l_employer_name||'';
730: l_str2 := ''||SUBSTR(l_employer_ssn,1,1)||'';
731: l_str3 := ''||SUBSTR(l_employer_ssn,2,1)||'';

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

1233: OPEN csr_get_address;
1234: FETCH csr_get_address INTO l_emp_address;
1235: CLOSE csr_get_address;
1236:
1237: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
1238:
1239: l_str1 := ''||l_employer_name||'';
1240: /**************l_str2 := ''||SUBSTR(l_employer_ssn,1,1)||'';
1241: l_str3 := ''||SUBSTR(l_employer_ssn,2,1)||'';

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

1810: vXMLTable.DELETE;
1811: vCtr := 1;
1812: hr_utility.set_location('Entering report168 ',10);
1813:
1814: l_effective_month := hr_general.decode_lookup('KW_GREGORIAN_MONTH', p_effective_month);
1815:
1816: vXMLTable(vCtr).TagName := 'R168-MONTH';
1817: vXMLTable(vCtr).TagValue := l_effective_month;
1818: vctr := vctr + 1;