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.

APPS.JAI_AR_EER1_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 2862: FROM jai_rgm_trx_records

2858: );
2859:
2860: CURSOR cur_dist_in(cp_start_date IN DATE) IS
2861: SELECT sum(credit_amount)
2862: FROM jai_rgm_trx_records
2863: WHERE source = 'SERVICE_DISTRIBUTE_IN'
2864: AND regime_code = 'SERVICE'
2865: AND tax_type = 'Service'
2866: AND regime_primary_regno = p_registration_number

Line 2872: FROM jai_rgm_trx_records

2868: AND (NVL(trunc(creation_date),trunc(SYSDATE))) <(NVL(cp_start_date,trunc(sysdate)));
2869:
2870: CURSOR cur_manual_in(cp_start_date IN DATE) IS
2871: SELECT sum(credit_amount)
2872: FROM jai_rgm_trx_records
2873: WHERE source = 'MANUAL'
2874: AND regime_code = 'SERVICE'
2875: AND tax_type = 'Service'
2876: AND source_trx_type IN ('ADJUSTMENT-RECOVERY','RECOVERY')

Line 2902: FROM jai_rgm_trx_records

2898: );
2899:
2900: CURSOR cur_ar_ser_dist_out_debit(cp_start_date IN DATE) IS
2901: SELECT nvl(sum(debit_amount),0)
2902: FROM jai_rgm_trx_records
2903: WHERE source = 'SERVICE_DISTRIBUTE_OUT'
2904: AND regime_code = 'SERVICE'
2905: AND tax_type = 'Service'
2906: AND regime_primary_regno = p_registration_number

Line 2912: FROM jai_rgm_trx_records

2908: AND (NVL(trunc(creation_date),trunc(SYSDATE))) <(NVL(cp_start_date,trunc(sysdate)));
2909:
2910: CURSOR cur_manual_debit(cp_start_date IN DATE) IS
2911: SELECT nvl(sum(debit_amount),0)
2912: FROM jai_rgm_trx_records
2913: WHERE source = 'MANUAL'
2914: AND regime_code = 'SERVICE'
2915: AND tax_type = 'Service'
2916: AND source_trx_type IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 2923: FROM jai_rgm_trx_records

2919: AND (NVL(trunc(creation_date),trunc(SYSDATE))) <(NVL(cp_start_date,trunc(sysdate)));
2920:
2921: CURSOR cur_payment(cp_start_date IN DATE) IS
2922: SELECT nvl(sum(debit_amount),0)
2923: FROM jai_rgm_trx_records
2924: WHERE source = 'MANUAL'
2925: AND regime_code = 'SERVICE'
2926: AND tax_type = ( 'Service' )
2927: AND source_trx_type = 'PAYMENT'

Line 2958: FROM jai_rgm_trx_records jrtr1,jai_rgm_trx_records jrtr2

2954: AND organization_id = nvl(p_operating_unit,organization_id)
2955: )
2956: UNION ALL
2957: SELECT jrtr1.credit_amount service_credit ,jrtr2.credit_amount edu_cess_credit
2958: FROM jai_rgm_trx_records jrtr1,jai_rgm_trx_records jrtr2
2959: WHERE jrtr1.source = 'SERVICE_DISTRIBUTE_IN'
2960: AND jrtr1.regime_code = 'SERVICE'
2961: AND jrtr1.tax_type = 'Service'
2962: AND jrtr2.tax_type(+) = 'SERVICE_EDUCATION_CESS'

Line 2970: FROM jai_rgm_trx_records jrtr1,jai_rgm_trx_records jrtr2

2966: AND (NVL(trunc(jrtr1.creation_date),trunc(SYSDATE))) BETWEEN (NVL(p_start_date,trunc(jrtr1.creation_date))) AND (NVL(p_end_date,trunc(SYSDATE)))
2967: AND to_char(jrtr1.creation_date, 'YYYY') || to_char(jrtr1.creation_date, 'MM') = ln_yyyymm
2968: UNION ALL
2969: SELECT jrtr1.credit_amount service_credit ,jrtr2.credit_amount edu_cess_credit
2970: FROM jai_rgm_trx_records jrtr1,jai_rgm_trx_records jrtr2
2971: WHERE jrtr1.source = 'MANUAL'
2972: AND jrtr1.regime_code = 'SERVICE'
2973: AND jrtr1.tax_type = 'Service'
2974: AND jrtr2.tax_type(+) = 'SERVICE_EDUCATION_CESS'

Line 3007: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records

3003: ;
3004:
3005:
3006: CURSOR cur_ar_ser_dist_out_debt IS
3007: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records
3008: WHERE source = 'SERVICE_DISTRIBUTE_OUT'
3009: AND regime_code = 'SERVICE'
3010: AND tax_type = 'Service'
3011: AND regime_primary_regno = p_registration_number

Line 3019: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records

3015: ;
3016:
3017:
3018: CURSOR cur_manual_debt IS
3019: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records
3020: WHERE source = 'MANUAL'
3021: AND regime_code = 'SERVICE'
3022: AND tax_type = 'Service'
3023: AND source_trx_type IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 3034: FROM jai_rgm_trx_records

3030:
3031:
3032: CURSOR cur_paymnt IS
3033: SELECT nvl(sum(debit_amount),0)
3034: FROM jai_rgm_trx_records
3035: WHERE source = 'MANUAL'
3036: AND regime_code = 'SERVICE'
3037: AND tax_type = 'Service'
3038: AND source_trx_type = 'PAYMENT'

Line 3065: SELECT sum(credit_amount) FROM jai_rgm_trx_records

3061: AND organization_id = nvl(p_operating_unit,organization_id)
3062: );
3063:
3064: CURSOR cur_dist_in1(cp_start_date IN DATE) IS
3065: SELECT sum(credit_amount) FROM jai_rgm_trx_records
3066: WHERE source = 'SERVICE_DISTRIBUTE_IN'
3067: AND regime_code = 'SERVICE'
3068: AND tax_type = 'SERVICE_EDUCATION_CESS'
3069: AND regime_primary_regno = p_registration_number

Line 3075: FROM jai_rgm_trx_records

3071: AND (NVL(trunc(creation_date),trunc(SYSDATE))) <(NVL(cp_start_date,trunc(sysdate)));
3072:
3073: CURSOR cur_manual_in1(cp_start_date IN DATE) IS
3074: SELECT sum(credit_amount)
3075: FROM jai_rgm_trx_records
3076: WHERE source = 'MANUAL'
3077: AND regime_code = 'SERVICE'
3078: AND tax_type = 'SERVICE_EDUCATION_CESS'
3079: AND source_trx_type IN ('ADJUSTMENT-RECOVERY','RECOVERY')

Line 3107: FROM jai_rgm_trx_records

3103:
3104:
3105: CURSOR cur_ar_ser_dist_out_debit1(cp_start_date IN DATE) IS
3106: SELECT nvl(sum(debit_amount),0)
3107: FROM jai_rgm_trx_records
3108: WHERE source = 'SERVICE_DISTRIBUTE_OUT'
3109: AND regime_code = 'SERVICE'
3110: AND tax_type = 'SERVICE_EDUCATION_CESS'
3111: AND regime_primary_regno = p_registration_number

Line 3117: FROM jai_rgm_trx_records

3113: AND (NVL(trunc(creation_date),trunc(SYSDATE))) <(NVL(cp_start_date,trunc(sysdate)));
3114:
3115: CURSOR cur_manual_debit1(cp_start_date IN DATE) IS
3116: SELECT nvl(sum(debit_amount),0)
3117: FROM jai_rgm_trx_records
3118: WHERE source = 'MANUAL'
3119: AND regime_code = 'SERVICE'
3120: AND tax_type = 'SERVICE_EDUCATION_CESS'
3121: AND source_trx_type IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 3128: FROM jai_rgm_trx_records

3124: AND (NVL(trunc(creation_date),trunc(SYSDATE))) <(NVL(cp_start_date,trunc(sysdate)));
3125:
3126: CURSOR cur_payment1(cp_start_date IN DATE) IS
3127: SELECT nvl(sum(debit_amount),0)
3128: FROM jai_rgm_trx_records
3129: WHERE source = 'MANUAL'
3130: AND regime_code = 'SERVICE'
3131: AND tax_type = 'SERVICE_EDUCATION_CESS'
3132: AND source_trx_type = 'PAYMENT'

Line 3158: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records

3154: AND to_char(creation_date, 'YYYY') || to_char(creation_date, 'MM') = ln_yyyymm ;
3155:
3156:
3157: CURSOR cur_ar_ser_dist_out_debt1 IS
3158: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records
3159: WHERE source = 'SERVICE_DISTRIBUTE_OUT'
3160: AND regime_code = 'SERVICE'
3161: AND tax_type = 'SERVICE_EDUCATION_CESS'
3162: AND regime_primary_regno = p_registration_number

Line 3171: FROM jai_rgm_trx_records

3167:
3168:
3169: CURSOR cur_manual_debt1 IS
3170: SELECT nvl(sum(debit_amount),0)
3171: FROM jai_rgm_trx_records
3172: WHERE source = 'MANUAL'
3173: AND regime_code = 'SERVICE'
3174: AND tax_type = 'SERVICE_EDUCATION_CESS'
3175: AND source_trx_type IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 3184: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records

3180: ;
3181:
3182:
3183: CURSOR cur_paymnt1 IS
3184: SELECT nvl(sum(debit_amount),0) FROM jai_rgm_trx_records
3185: WHERE source = 'MANUAL'
3186: AND regime_code = 'SERVICE'
3187: AND tax_type = 'SERVICE_EDUCATION_CESS'
3188: AND source_trx_type = 'PAYMENT'