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.

[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on HR_LOCATIONS_ALL

Line 5074: FROM hr_locations_all

5070: -- to get address details of location linked to given organization
5071: CURSOR c_address_details(p_location_id IN NUMBER) IS
5072: SELECT location_code, address_line_1, address_line_2, address_line_3, null, null,
5073: REPLACE(postal_code, ' ') postal_code
5074: FROM hr_locations_all
5075: WHERE location_id = p_location_id;
5076:
5077: -- gives the Deductee code based on Vendor Classification
5078: CURSOR c_deductee_dtls(p_vendor_id IN NUMBER) IS

Line 5590: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;

5586: v_tan_pin NUMBER(6);
5587: v_quarterlyOrYearly VARCHAR2(2); -- := 'Y'; -- as given by Vikram File.Sql.35 by Brathod
5588:
5589: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
5590: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
5591: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
5592: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
5593: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
5594: v_tan_address4 VARCHAR2(75);

Line 5591: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

5587: v_quarterlyOrYearly VARCHAR2(2); -- := 'Y'; -- as given by Vikram File.Sql.35 by Brathod
5588:
5589: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
5590: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
5591: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
5592: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
5593: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
5594: v_tan_address4 VARCHAR2(75);
5595: v_tan_address5 VARCHAR2(75);

Line 5592: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

5588:
5589: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
5590: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
5591: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
5592: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
5593: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
5594: v_tan_address4 VARCHAR2(75);
5595: v_tan_address5 VARCHAR2(75);
5596: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 5593: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

5589: -- added location_code and modified the types of address variables to refer table column types by Vijay Shankar for Bug#4057192
5590: v_location_code HR_LOCATIONS_ALL.location_code%TYPE;
5591: v_tan_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
5592: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
5593: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
5594: v_tan_address4 VARCHAR2(75);
5595: v_tan_address5 VARCHAR2(75);
5596: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
5597: v_totTaxDeductedAsPerChallan NUMBER;

Line 5596: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

5592: v_tan_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
5593: v_tan_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
5594: v_tan_address4 VARCHAR2(75);
5595: v_tan_address5 VARCHAR2(75);
5596: v_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
5597: v_totTaxDeductedAsPerChallan NUMBER;
5598: v_totTaxDeductedAsPerDeductee NUMBER := 0; /*Bug 10315928 - Initialize the Batch Total of - Total of Deposit Amount as per Challan*/
5599:
5600: v_challan_dtl_slno NUMBER; --File.Sql.35 Cbabu := 0;