APPS.JAI_ETCS_PKG dependencies on JAI_AR_ETCS_T

Line 2318: from jai_ar_etcs_t for update ;

2314:
2315: cursor c_get_recs
2316: is
2317: select *
2318: from jai_ar_etcs_t for update ;
2319:
2320: cursor c_line_amt(cp_source_document_ref_id number, cp_check_id in number) is
2321: select nvl(sum(line_amt),0)
2322: from jai_rgm_refs_all jra

Line 2392: insert into jai_ar_etcs_t

2388: lv_doc_date date ;
2389:
2390: BEGIN
2391:
2392: insert into jai_ar_etcs_t
2393: (
2394: Batch_id ,
2395: tcs_check_id ,
2396: check_number ,

Line 2553: update jai_ar_etcs_t

2549:
2550: FND_FILE.put_line(FND_FILE.log, ' lv_customer_type : ' || lv_customer_type || 'lv_pan_no : ' || lv_pan_no || ' lv_doc_date : ' || lv_doc_date ||
2551: ' v_bank_branch_code : ' || v_bank_branch_code ) ;
2552:
2553: update jai_ar_etcs_t
2554: set
2555: line_amt = ln_line_amt ,
2556: tcs_amt = ln_tcs_amount ,
2557: surcharge_amt = ln_surcharge_amount ,

Line 2809: jai_ar_etcs_t

2805: cursor c_deductee_cnt
2806: is
2807: select count(1), nvl(sum(tcs_amt + surcharge_amt + cess_amt),0)
2808: from
2809: jai_ar_etcs_t
2810: where
2811: batch_id = ln_batch_id ;
2812:
2813: CURSOR c_quart_deductee_cnt(cp_batch_id IN NUMBER , cp_check_number IN NUMBER ) IS

Line 2815: from jai_ar_etcs_t

2811: batch_id = ln_batch_id ;
2812:
2813: CURSOR c_quart_deductee_cnt(cp_batch_id IN NUMBER , cp_check_number IN NUMBER ) IS
2814: select sum ( count( distinct tcs_tax_rate ) )
2815: from jai_ar_etcs_t
2816: WHERE batch_id = cp_batch_id
2817: and check_number = cp_check_number
2818: group by source_document_id, tcs_tax_rate, exempted_flag ;
2819:

Line 2827: jai_ar_etcs_t

2823: select count(1)
2824: from
2825: ( select 1
2826: from
2827: jai_ar_etcs_t
2828: where
2829: batch_id = ln_batch_id
2830: group by
2831: NVL(challan_no, 'No Challan Number'),

Line 2874: from jai_ar_etcs_t a

2870: sum(tcs_amt + surcharge_amt + cess_amt ) total_tcs_amount,
2871: sum(tcs_amt) tcs_amt,
2872: sum(surcharge_amt) surcharge_amt,
2873: sum(cess_amt) cess_amt
2874: from jai_ar_etcs_t a
2875: where a.batch_id = p_batch_id
2876: group by NVL(bank_branch_code,'No Bank Branch'),
2877: NVL(challan_no,'No Challan Number'), NVL(challan_date,lv_dummy_date),
2878: check_number, tcs_check_id;

Line 2971: from jai_ar_etcs_t a

2967: sum(tcs_amt) tcs_amt,
2968: sum(surcharge_amt) surcharge_amt,
2969: sum(cess_amt) cess_amt,
2970: sum(tcs_amt + surcharge_amt + cess_amt ) total_tcs_amount
2971: from jai_ar_etcs_t a
2972: where a.batch_id = p_batch_id and
2973: challan_line_num = NVL(p_challan_line_num, challan_line_num)
2974: group by
2975: challan_line_num, party_id, party_site_id,exempted_flag, tcs_tax_rate,

Line 3173: UPDATE jai_ar_etcs_t

3169: END IF ;
3170:
3171: END IF ;
3172:
3173: UPDATE jai_ar_etcs_t
3174: SET deductee_line_num = v_line_number
3175: WHERE batch_id = ln_batch_id
3176: and challan_line_num = dd.challan_line_num
3177: and party_id = dd.party_id

Line 3910: UPDATE jai_ar_etcs_t

3906: ) ;
3907: END IF ;
3908: END IF ;
3909:
3910: UPDATE jai_ar_etcs_t
3911: SET challan_line_num = v_line_number
3912: WHERE batch_id = ln_batch_id
3913: and nvl(challan_no,'No Challan Number') = nvl(cd.challan_no, 'No Challan Number')
3914: and nvl(challan_date, lv_dummy_date) = nvl(cd.challan_date, lv_dummy_date )