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 1876: l_bank_name := hr_general.decode_lookup('AE_BANK_NAMES',rec_pers_pay.name_id);

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

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

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

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

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