APPS.JAI_ETCS_PKG dependencies on HR_LOCATIONS_ALL

Line 2662: FROM hr_locations_all

2658: -- to get address details of location linked to given organization
2659: CURSOR c_address_details(p_location_id IN NUMBER) IS
2660: SELECT location_code, address_line_1, address_line_2, address_line_3, null, null,
2661: replace(postal_code, ' ') postal_code
2662: FROM hr_locations_all
2663: WHERE location_id = p_location_id;
2664:
2665: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
2666: Select Error_Message from jai_ap_etds_errors_t

Line 2671: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;

2667: where batch_id = cp_batch_id ;
2668:
2669: ln_errors_exist number ;
2670:
2671: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2672: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2673: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2674: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2675: v_tan_address4 VARCHAR2(75);

Line 2672: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

2668:
2669: ln_errors_exist number ;
2670:
2671: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2672: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2673: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2674: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2675: v_tan_address4 VARCHAR2(75);
2676: v_tan_address5 VARCHAR2(75);

Line 2673: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

2669: ln_errors_exist number ;
2670:
2671: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2672: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2673: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2674: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2675: v_tan_address4 VARCHAR2(75);
2676: v_tan_address5 VARCHAR2(75);
2677: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2674: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

2670:
2671: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
2672: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2673: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2674: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2675: v_tan_address4 VARCHAR2(75);
2676: v_tan_address5 VARCHAR2(75);
2677: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2678: v_tan_pin NUMBER(6);

Line 2677: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2673: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2674: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2675: v_tan_address4 VARCHAR2(75);
2676: v_tan_address5 VARCHAR2(75);
2677: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2678: v_tan_pin NUMBER(6);
2679:
2680: ln_batch_id number ;
2681: lv_etcs_yearly_returns varchar2(1) ;