APPS.JAI_ETCS_PKG dependencies on HR_LOCATIONS_ALL

Line 2202: FROM hr_locations_all

2198: -- to get address details of location linked to given organization
2199: CURSOR c_address_details(p_location_id IN NUMBER) IS
2200: SELECT location_code, address_line_1, address_line_2, address_line_3, null, null,
2201: replace(postal_code, ' ') postal_code
2202: FROM hr_locations_all
2203: WHERE location_id = p_location_id;
2204:
2205: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
2206: Select Error_Message from jai_ap_etds_errors_t

Line 2211: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;

2207: where batch_id = cp_batch_id ;
2208:
2209: ln_errors_exist number ;
2210:
2211: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2212: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2213: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2214: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2215: v_tan_address4 VARCHAR2(75);

Line 2212: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

2208:
2209: ln_errors_exist number ;
2210:
2211: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2212: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2213: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2214: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2215: v_tan_address4 VARCHAR2(75);
2216: v_tan_address5 VARCHAR2(75);

Line 2213: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

2209: ln_errors_exist number ;
2210:
2211: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2212: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2213: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2214: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2215: v_tan_address4 VARCHAR2(75);
2216: v_tan_address5 VARCHAR2(75);
2217: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2214: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

2210:
2211: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2212: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2213: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2214: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2215: v_tan_address4 VARCHAR2(75);
2216: v_tan_address5 VARCHAR2(75);
2217: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2218: v_tan_pin NUMBER(6);

Line 2217: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2213: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2214: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2215: v_tan_address4 VARCHAR2(75);
2216: v_tan_address5 VARCHAR2(75);
2217: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2218: v_tan_pin NUMBER(6);
2219:
2220: ln_batch_id number ;
2221: lv_etcs_yearly_returns varchar2(1) ;