DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on HR_GENERAL

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

1142: FETCH csr_hire_date INTO l_hire_date;
1143: CLOSE csr_hire_date;
1144:
1145: /*NATIONALITY*/
1146: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1147:
1148: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1149:
1150: /*Local Unit*/

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

1216:
1217: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1218:
1219: IF rec_primary_address.style = 'DK' THEN
1220: l_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_primary_address.postal_code);
1221: ELSE
1222: l_postal_code := rec_primary_address.postal_code;
1223: END IF;
1224:

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

1224:
1225: l_country := PAY_DK_ARCHIVE.get_country_name(rec_primary_address.country);
1226:
1227: IF rec_employer_address.style = 'DK' THEN
1228: l_emp_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_employer_address.postal_code);
1229: ELSE
1230: l_emp_postal_code := rec_employer_address.postal_code;
1231: END IF;
1232:

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

1708: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1709:
1710: --l_bank_reg_num := rec_pers_pay.bank_reg_num;
1711: l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' ||
1712: hr_general.decode_lookup('HR_DK_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
1713:
1714: pay_action_information_api.create_action_information (
1715: p_action_information_id => l_action_info_id
1716: ,p_action_context_id => p_archive_assact_id

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

1846: CURSOR csr_leave_balance
1847: IS
1848: --
1849: SELECT pap.accrual_plan_name
1850: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
1851: ,pap.accrual_units_of_measure
1852: ,ppa.payroll_id
1853: ,pap.business_group_id
1854: ,pap.accrual_plan_id

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

2881:
2882: -- fnd_file.put_line(fnd_file.log,'getting DK_TAX_CARD_TYPE');
2883:
2884: -- Getting the display value for Tax Card type
2885: g_tax_card_tab(2).screen_entry_val := hr_general.decode_lookup('DK_TAX_CARD_TYPE',g_tax_card_tab(2).screen_entry_val);
2886:
2887: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');
2888:
2889: pay_action_information_api.create_action_information (