APPS.JAI_ETCS_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 2300: from JAI_CMN_CUS_ADDRESSES

2296:
2297: cursor c_pan_no(cp_party_id in number)
2298: is
2299: select pan_no
2300: from JAI_CMN_CUS_ADDRESSES
2301: where customer_id = cp_party_id
2302: and confirm_pan = 'Y'
2303: and pan_no is not null
2304: and rownum = 1 ;

Line 2310: from JAI_CMN_CUS_ADDRESSES jca

2306: cursor c_buyer_code(cp_party_id in number)
2307: is
2308: select
2309: DECODE(jca.tcs_customer_type, 'COMPANIES', '01', 'OTHERS', '02') buyer_code
2310: from JAI_CMN_CUS_ADDRESSES jca
2311: where jca.customer_id = cp_party_id
2312: and jca.tcs_customer_type is not null
2313: and rownum = 1 ;
2314:

Line 2336: lv_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%TYPE ;

2332:
2333: ln_line_amt number ;
2334:
2335: lv_customer_type varchar2(2) ;
2336: lv_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%TYPE ;
2337: lv_item_classification jai_rgm_lookups.display_value%type ;
2338: ln_tcs_amount number ;
2339: ln_surcharge_amount number ;
2340: ln_cess_amount number ;