DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on HR_GENERAL

Line 1086: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',rec_person_details.nationality);

1082: FETCH csr_cost_center INTO l_cost_center;
1083: CLOSE csr_cost_center;
1084:
1085: /*NATIONALITY*/
1086: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',rec_person_details.nationality);
1087:
1088: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1089:
1090: l_org_struct_ver_id := NULL;

Line 1875: l_bank_name := hr_general.decode_lookup('AE_BANK_NAMES',rec_pers_pay.name_id);

1871:
1872: IF (l_ext_acct IS NOT NULL) THEN
1873: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1874:
1875: l_bank_name := hr_general.decode_lookup('AE_BANK_NAMES',rec_pers_pay.name_id);
1876: l_branch_name := hr_general.decode_lookup('AE_BRANCH_NAMES',rec_pers_pay.branch);
1877:
1878: pay_action_information_api.create_action_information (
1879: p_action_information_id => l_action_info_id

Line 1876: l_branch_name := hr_general.decode_lookup('AE_BRANCH_NAMES',rec_pers_pay.branch);

1872: IF (l_ext_acct IS NOT NULL) THEN
1873: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1874:
1875: l_bank_name := hr_general.decode_lookup('AE_BANK_NAMES',rec_pers_pay.name_id);
1876: l_branch_name := hr_general.decode_lookup('AE_BRANCH_NAMES',rec_pers_pay.branch);
1877:
1878: pay_action_information_api.create_action_information (
1879: p_action_information_id => l_action_info_id
1880: ,p_action_context_id => p_archive_assact_id

Line 2264: l_uom := hr_general.decode_lookup('UNITS',g_user_balance_table(l_index).uom);

2260: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2261:
2262: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2263:
2264: l_uom := hr_general.decode_lookup('UNITS',g_user_balance_table(l_index).uom);
2265:
2266:
2267: IF l_balance_value > 0 THEN
2268: