APPS.JAI_ETCS_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 1869: from JAI_CMN_CUS_ADDRESSES

1865:
1866: cursor c_pan_no(cp_party_id in number)
1867: is
1868: select pan_no
1869: from JAI_CMN_CUS_ADDRESSES
1870: where customer_id = cp_party_id
1871: and confirm_pan = 'Y'
1872: and pan_no is not null
1873: and rownum = 1 ;

Line 1879: from JAI_CMN_CUS_ADDRESSES jca

1875: cursor c_buyer_code(cp_party_id in number)
1876: is
1877: select
1878: DECODE(jca.tcs_customer_type, 'COMPANIES', '01', 'OTHERS', '02') buyer_code
1879: from JAI_CMN_CUS_ADDRESSES jca
1880: where jca.customer_id = cp_party_id
1881: and jca.tcs_customer_type is not null
1882: and rownum = 1 ;
1883:

Line 1905: lv_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%TYPE ;

1901:
1902: ln_line_amt number ;
1903:
1904: lv_customer_type varchar2(2) ;
1905: lv_pan_no JAI_CMN_CUS_ADDRESSES.pan_no%TYPE ;
1906: lv_item_classification jai_rgm_lookups.display_value%type ;
1907: ln_tcs_amount number ;
1908: ln_surcharge_amount number ;
1909: ln_cess_amount number ;