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_NO_EOY_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 939: ,hr_locations_all loc

935: ,loc.postal_code postcode
936: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
937: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
938: FROM hr_all_organization_units org
939: ,hr_locations_all loc
940: WHERE org.organization_id = p_organization_id
941: AND loc.location_id (+) = org.location_id;
942: --
943: l_org_dtl_rec csr_ORG_DETAILS%ROWTYPE;

Line 1314: l_le_addr1 hr_locations_all.address_line_1%TYPE;

1310: l_le_si_count NUMBER := 0;
1311: l_le_si_bal_table t_le_si_bal_table;
1312: l_bal_value NUMBER := 0;
1313: l_le_name hr_all_organization_units.name%TYPE;
1314: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);

Line 1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;

1311: l_le_si_bal_table t_le_si_bal_table;
1312: l_bal_value NUMBER := 0;
1313: l_le_name hr_all_organization_units.name%TYPE;
1314: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;

Line 1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;

1312: l_bal_value NUMBER := 0;
1313: l_le_name hr_all_organization_units.name%TYPE;
1314: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;

Line 1317: l_le_postcode hr_locations_all.postal_code%TYPE;

1313: l_le_name hr_all_organization_units.name%TYPE;
1314: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1315: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;

Line 1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;

1316: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1322: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1323: l_to_postcode hr_locations_all.postal_code%TYPE;
1324: l_to_postoffice VARCHAR2(100);

Line 1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;

1317: l_le_postcode hr_locations_all.postal_code%TYPE;
1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1322: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1323: l_to_postcode hr_locations_all.postal_code%TYPE;
1324: l_to_postoffice VARCHAR2(100);
1325: l_ni_zone_arc VARCHAR2(10);

Line 1322: l_to_addr3 hr_locations_all.address_line_3%TYPE;

1318: l_le_postoffice VARCHAR2(100);
1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1322: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1323: l_to_postcode hr_locations_all.postal_code%TYPE;
1324: l_to_postoffice VARCHAR2(100);
1325: l_ni_zone_arc VARCHAR2(10);
1326: l_tax_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Tax', '_TU_LU_YTD');

Line 1323: l_to_postcode hr_locations_all.postal_code%TYPE;

1319: l_to_name hr_all_organization_units.name%TYPE;
1320: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1321: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1322: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1323: l_to_postcode hr_locations_all.postal_code%TYPE;
1324: l_to_postoffice VARCHAR2(100);
1325: l_ni_zone_arc VARCHAR2(10);
1326: l_tax_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Tax', '_TU_LU_YTD');
1327: l_ec_spcl_pct_bse_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Employer Contribution Special Percentage Base', '_TU_LU_YTD');