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 1075: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);

1071: FETCH csr_cost_center INTO l_cost_center;
1072: CLOSE csr_cost_center;
1073:
1074: /*NATIONALITY*/
1075: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1076:
1077: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1078:
1079: l_org_struct_ver_id := NULL;

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

1106:
1107: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1108: l_city := null;
1109: IF rec_primary_address.style = 'SA' THEN
1110: l_city:= hr_general.decode_lookup('SA_CITY',rec_primary_address.city);
1111: ELSE
1112: l_city:= rec_primary_address.city;
1113: END IF;
1114:

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

1114:
1115: l_country:=PAY_SA_ARCHIVE.get_country_name(rec_primary_address.country);
1116: l_emp_city := null;
1117: IF rec_employer_address.style = 'SA' THEN
1118: l_emp_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1119: ELSE
1120: l_emp_city:= rec_employer_address.city;
1121: END IF;
1122:

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

1122:
1123: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);
1124: l_org_city := null;
1125: IF rec_org_address.style = 'SA' THEN
1126: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1127: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);
1128: ELSE
1129: --l_org_city:= rec_employer_address.city;
1130: l_org_city:= rec_org_address.city;

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

1123: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);
1124: l_org_city := null;
1125: IF rec_org_address.style = 'SA' THEN
1126: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1127: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);
1128: ELSE
1129: --l_org_city:= rec_employer_address.city;
1130: l_org_city:= rec_org_address.city;
1131: END IF;

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

1630:
1631: IF (l_ext_acct IS NOT NULL) THEN
1632: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1633:
1634: l_bank_name := hr_general.decode_lookup('SA_BANKS',rec_pers_pay.name_id);
1635:
1636: pay_action_information_api.create_action_information (
1637: p_action_information_id => l_action_info_id
1638: ,p_action_context_id => p_archive_assact_id

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

1767: CURSOR csr_leave_balance
1768: IS
1769: --
1770: SELECT pap.accrual_plan_name
1771: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category) accrual_catgry
1772: ,pap.accrual_units_of_measure
1773: ,ppa.payroll_id
1774: ,pap.business_group_id
1775: ,pap.accrual_plan_id