eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SA_ARCHIVE dependencies on HR_GENERAL

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

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

Line 1123: l_city:= hr_general.decode_lookup('SA_CITY',rec_primary_address.city);

1119:
1120: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1121: l_city := null;
1122: IF rec_primary_address.style = 'SA' THEN
1123: l_city:= hr_general.decode_lookup('SA_CITY',rec_primary_address.city);
1124: ELSE
1125: l_city:= rec_primary_address.city;
1126: END IF;
1127:

Line 1131: l_emp_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);

1127:
1128: l_country:=PAY_SA_ARCHIVE.get_country_name(rec_primary_address.country);
1129: l_emp_city := null;
1130: IF rec_employer_address.style = 'SA' THEN
1131: l_emp_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1132: ELSE
1133: l_emp_city:= rec_employer_address.city;
1134: END IF;
1135:

Line 1139: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);

1135:
1136: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);
1137: l_org_city := null;
1138: IF rec_org_address.style = 'SA' THEN
1139: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1140: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);
1141: ELSE
1142: --l_org_city:= rec_employer_address.city;
1143: l_org_city:= rec_org_address.city;

Line 1140: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);

1136: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);
1137: l_org_city := null;
1138: IF rec_org_address.style = 'SA' THEN
1139: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1140: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);
1141: ELSE
1142: --l_org_city:= rec_employer_address.city;
1143: l_org_city:= rec_org_address.city;
1144: END IF;

Line 1742: l_bank_name := hr_general.decode_lookup('SA_BANKS',rec_pers_pay.name_id);

1738:
1739: IF (l_ext_acct IS NOT NULL) THEN
1740: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1741:
1742: l_bank_name := hr_general.decode_lookup('SA_BANKS',rec_pers_pay.name_id);
1743:
1744: pay_action_information_api.create_action_information (
1745: p_action_information_id => l_action_info_id
1746: ,p_action_context_id => p_archive_assact_id

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

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