APPS.JAI_AR_EER1_PKG dependencies on JAI_RGM_TRX_REFS

Line 2844: FROM jai_rgm_trx_refs

2840:
2841: -- Cursors for opening Balance (Service Tax)
2842: CURSOR cur_invoice_open_bal(cp_start_date IN DATE) IS
2843: SELECT sum(recovered_amount)
2844: FROM jai_rgm_trx_refs
2845: WHERE source = 'AP'
2846: AND tax_type = 'Service'
2847: AND trunc(creation_date) < cp_start_date
2848: AND organization_id in

Line 2884: FROM jai_rgm_trx_refs

2880:
2881:
2882: CURSOR cur_ar_util_credit(cp_start_date IN DATE) IS
2883: SELECT SUM(recovered_amount)
2884: FROM jai_rgm_trx_refs
2885: WHERE source = 'AR'
2886: AND tax_type = 'Service'
2887: AND trunc(creation_date) < cp_start_date
2888: AND organization_id IN

Line 2938: FROM jai_rgm_trx_refs jrtf1 ,jai_rgm_trx_refs jrtf2

2934: CURSOR cur_st_cess IS
2935: SELECT nvl(sum(service_credit),0),nvl(sum(edu_cess_credit),0)
2936: FROM (
2937: SELECT jrtf1.recovered_amount service_credit ,jrtf2.recovered_amount edu_cess_credit
2938: FROM jai_rgm_trx_refs jrtf1 ,jai_rgm_trx_refs jrtf2
2939: WHERE jrtf1.source = 'AP'
2940: AND jrtf1.invoice_id = jrtf2.invoice_id(+)
2941: AND jrtf1.tax_type = 'Service'
2942: AND jrtf2.tax_type(+) = 'SERVICE_EDUCATION_CESS'

Line 2987: SELECT SUM(recovered_amount) FROM jai_rgm_trx_refs

2983: ;
2984:
2985: -- Cursors for Credit utilised (services)
2986: CURSOR cur_ar_util_credt IS
2987: SELECT SUM(recovered_amount) FROM jai_rgm_trx_refs
2988: WHERE source = 'AR'
2989: AND tax_type = 'Service'
2990: AND organization_id IN
2991: (

Line 3048: SELECT sum(recovered_amount) FROM jai_rgm_trx_refs

3044:
3045:
3046: -- Cursors for opening balance
3047: CURSOR cur_invoice_open_bal1(cp_start_date IN DATE) IS
3048: SELECT sum(recovered_amount) FROM jai_rgm_trx_refs
3049: WHERE source = 'AP'
3050: AND tax_type = 'SERVICE_EDUCATION_CESS'
3051: AND trunc(creation_date) < cp_start_date
3052: AND organization_id in

Line 3087: FROM jai_rgm_trx_refs

3083:
3084:
3085: CURSOR cur_ar_util_credit1(cp_start_date IN DATE) IS
3086: SELECT SUM(recovered_amount)
3087: FROM jai_rgm_trx_refs
3088: WHERE source = 'AR'
3089: AND tax_type = 'SERVICE_EDUCATION_CESS'
3090: AND trunc(creation_date) < cp_start_date
3091: AND organization_id IN

Line 3139: SELECT SUM(recovered_amount) FROM jai_rgm_trx_refs

3135: AND (NVL(trunc(creation_date),trunc(SYSDATE))) < (NVL(cp_start_date,trunc(sysdate)));
3136:
3137: -- Cursors for the Credit utilised (services)
3138: CURSOR cur_ar_util_credt1 IS
3139: SELECT SUM(recovered_amount) FROM jai_rgm_trx_refs
3140: WHERE source = 'AR'
3141: AND tax_type = 'SERVICE_EDUCATION_CESS'
3142: AND organization_id IN
3143: (