APPS.PAY_DK_ARCHIVE dependencies on HR_GENERAL

Line 1156: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);

1152: FETCH csr_hire_date INTO l_hire_date;
1153: CLOSE csr_hire_date;
1154:
1155: /*NATIONALITY*/
1156: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1157:
1158: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1159:
1160: /*Local Unit*/

Line 1230: l_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_primary_address.postal_code);

1226:
1227: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1228:
1229: IF rec_primary_address.style = 'DK' THEN
1230: l_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_primary_address.postal_code);
1231: ELSIF rec_primary_address.style = 'DK_GLB' and rec_primary_address.city is not null THEN /* 10327065 start */
1232: l_postal_code := rec_primary_address.postal_code || ' ' || rec_primary_address.city;
1233: /* 10327065 end */
1234: ELSE

Line 1241: l_emp_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_employer_address.postal_code);

1237:
1238: l_country := PAY_DK_ARCHIVE.get_country_name(rec_primary_address.country);
1239:
1240: IF rec_employer_address.style = 'DK' THEN
1241: l_emp_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_employer_address.postal_code);
1242: ELSE
1243: l_emp_postal_code := rec_employer_address.postal_code;
1244: END IF;
1245:

Line 1740: hr_general.decode_lookup('HR_DK_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);

1736: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1737:
1738: --l_bank_reg_num := rec_pers_pay.bank_reg_num;
1739: l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' ||
1740: hr_general.decode_lookup('HR_DK_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
1741:
1742: pay_action_information_api.create_action_information (
1743: p_action_information_id => l_action_info_id
1744: ,p_action_context_id => p_archive_assact_id

Line 1878: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)

1874: CURSOR csr_leave_balance
1875: IS
1876: --
1877: SELECT pap.accrual_plan_name
1878: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
1879: ,pap.accrual_units_of_measure
1880: ,ppa.payroll_id
1881: ,pap.business_group_id
1882: ,pap.accrual_plan_id

Line 3327: g_tax_card_tab(2).screen_entry_val := hr_general.decode_lookup('DK_TAX_CARD_TYPE',g_tax_card_tab(2).screen_entry_val);

3323:
3324: -- fnd_file.put_line(fnd_file.log,'getting DK_TAX_CARD_TYPE');
3325:
3326: -- Getting the display value for Tax Card type
3327: g_tax_card_tab(2).screen_entry_val := hr_general.decode_lookup('DK_TAX_CARD_TYPE',g_tax_card_tab(2).screen_entry_val);
3328:
3329: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');
3330:
3331: pay_action_information_api.create_action_information (