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 846: ,hr_locations_all loc

842: ,loc.postal_code postcode
843: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
844: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
845: FROM hr_all_organization_units org
846: ,hr_locations_all loc
847: WHERE org.organization_id = p_organization_id
848: AND loc.location_id (+) = org.location_id;
849: --
850: l_org_dtl_rec csr_ORG_DETAILS%ROWTYPE;

Line 1163: l_le_addr1 hr_locations_all.address_line_1%TYPE;

1159: l_le_si_count NUMBER := 0;
1160: l_le_si_bal_table t_le_si_bal_table;
1161: l_bal_value NUMBER := 0;
1162: l_le_name hr_all_organization_units.name%TYPE;
1163: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);

Line 1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;

1160: l_le_si_bal_table t_le_si_bal_table;
1161: l_bal_value NUMBER := 0;
1162: l_le_name hr_all_organization_units.name%TYPE;
1163: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;

Line 1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;

1161: l_bal_value NUMBER := 0;
1162: l_le_name hr_all_organization_units.name%TYPE;
1163: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;

Line 1166: l_le_postcode hr_locations_all.postal_code%TYPE;

1162: l_le_name hr_all_organization_units.name%TYPE;
1163: l_le_addr1 hr_locations_all.address_line_1%TYPE;
1164: l_le_addr2 hr_locations_all.address_line_2%TYPE;
1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;

Line 1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;

1165: l_le_addr3 hr_locations_all.address_line_3%TYPE;
1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1171: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1172: l_to_postcode hr_locations_all.postal_code%TYPE;
1173: l_to_postoffice VARCHAR2(100);

Line 1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;

1166: l_le_postcode hr_locations_all.postal_code%TYPE;
1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1171: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1172: l_to_postcode hr_locations_all.postal_code%TYPE;
1173: l_to_postoffice VARCHAR2(100);
1174: l_ni_zone_arc VARCHAR2(10);

Line 1171: l_to_addr3 hr_locations_all.address_line_3%TYPE;

1167: l_le_postoffice VARCHAR2(100);
1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1171: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1172: l_to_postcode hr_locations_all.postal_code%TYPE;
1173: l_to_postoffice VARCHAR2(100);
1174: l_ni_zone_arc VARCHAR2(10);
1175: l_tax_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Tax', '_TU_LU_YTD');

Line 1172: l_to_postcode hr_locations_all.postal_code%TYPE;

1168: l_to_name hr_all_organization_units.name%TYPE;
1169: l_to_addr1 hr_locations_all.address_line_1%TYPE;
1170: l_to_addr2 hr_locations_all.address_line_2%TYPE;
1171: l_to_addr3 hr_locations_all.address_line_3%TYPE;
1172: l_to_postcode hr_locations_all.postal_code%TYPE;
1173: l_to_postoffice VARCHAR2(100);
1174: l_ni_zone_arc VARCHAR2(10);
1175: l_tax_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Tax', '_TU_LU_YTD');
1176: l_ec_spcl_pct_bse_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Employer Contribution Special Percentage Base', '_TU_LU_YTD');