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.JAI_AP_TDS_ETDS_PKG dependencies on HR_LOCATIONS_ALL

Line 3137: FROM hr_locations_all

3133: -- to get address details of location linked to given organization
3134: CURSOR c_address_details(p_location_id IN NUMBER) IS
3135: SELECT location_code, address_line_1, address_line_2, address_line_3, null, null,
3136: REPLACE(postal_code, ' ') postal_code
3137: FROM hr_locations_all
3138: WHERE location_id = p_location_id;
3139:
3140: -- gives the Deductee code based on Vendor Classification
3141: CURSOR c_deductee_dtls(p_vendor_id IN NUMBER) IS

Line 3377: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;

3373: v_tan_pin NUMBER(6);
3374: v_quarterlyOrYearly VARCHAR2(2); -- := 'Y'; -- as given by Vikram File.Sql.35 by Brathod
3375:
3376: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
3377: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
3378: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
3379: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
3380: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
3381: v_tan_address4 VARCHAR2(75);

Line 3378: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

3374: v_quarterlyOrYearly VARCHAR2(2); -- := 'Y'; -- as given by Vikram File.Sql.35 by Brathod
3375:
3376: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
3377: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
3378: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
3379: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
3380: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
3381: v_tan_address4 VARCHAR2(75);
3382: v_tan_address5 VARCHAR2(75);

Line 3379: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

3375:
3376: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
3377: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
3378: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
3379: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
3380: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
3381: v_tan_address4 VARCHAR2(75);
3382: v_tan_address5 VARCHAR2(75);
3383: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 3380: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

3376: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
3377: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
3378: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
3379: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
3380: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
3381: v_tan_address4 VARCHAR2(75);
3382: v_tan_address5 VARCHAR2(75);
3383: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
3384: v_totTaxDeductedAsPerChallan NUMBER;

Line 3383: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

3379: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
3380: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
3381: v_tan_address4 VARCHAR2(75);
3382: v_tan_address5 VARCHAR2(75);
3383: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
3384: v_totTaxDeductedAsPerChallan NUMBER;
3385: v_totTaxDeductedAsPerDeductee NUMBER;
3386:
3387: v_challan_dtl_slno NUMBER; --File.Sql.35 Cbabu := 0;