APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_DEFINITIONS

Line 418: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784

414: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.punch_settlement_id';
415:
416: CURSOR cur_regime_code IS /* 4245365*/
417: SELECT regime_code
418: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784
419: WHERE regime_id = p_regime_id;
420: lv_regime JAI_RGM_DEFINITIONS.regime_code%TYPE;
421:
422: BEGIN

Line 420: lv_regime JAI_RGM_DEFINITIONS.regime_code%TYPE;

416: CURSOR cur_regime_code IS /* 4245365*/
417: SELECT regime_code
418: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784
419: WHERE regime_id = p_regime_id;
420: lv_regime JAI_RGM_DEFINITIONS.regime_code%TYPE;
421:
422: BEGIN
423: OPEN cur_regime_code; /* 4245365*/
424: FETCH cur_regime_code INTO lv_regime;

Line 489: FROM JAI_RGM_DEFINITIONS

485: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;
486:
487: CURSOR c_regime_code IS
488: SELECT regime_code
489: FROM JAI_RGM_DEFINITIONS
490: WHERE regime_id = p_regime_id;
491: -- ld_trx_date DATE; /* commented by ssawant for bug 5662296*/
492: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
493:

Line 492: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

488: SELECT regime_code
489: FROM JAI_RGM_DEFINITIONS
490: WHERE regime_id = p_regime_id;
491: -- ld_trx_date DATE; /* commented by ssawant for bug 5662296*/
492: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
493:
494: /*Bug 5879769 bduvarag start*/
495:
496: CURSOR cur_inv_payment (cp_service_type_code VARCHAR2) /*Added by nprashar for bug # 6359082*/

Line 606: jai_rgm_definitions jrg

602: AND source_trx_type = 'Invoice Payment'
603: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
604: FROM jai_rgm_stl_balances jbal,
605: jai_rgm_settlements jstl,
606: jai_rgm_definitions jrg
607: WHERE jbal.settlement_id = jstl.settlement_id
608: AND jrg.regime_id = jstl.regime_id
609: AND jrg.regime_code = 'VAT'
610: AND jstl.primary_registration_no = p_regn_no

Line 632: jai_rgm_definitions jrg

628: FROM jai_rgm_stl_balances
629: WHERE settlement_id = ( SELECT MAX(jbal.settlement_id)
630: FROM jai_rgm_stl_balances jbal,
631: jai_rgm_settlements jstl,
632: jai_rgm_definitions jrg
633: WHERE jbal.settlement_id = jstl.settlement_id
634: AND jrg.regime_id = jstl.regime_id
635: AND jrg.regime_code = 'VAT'
636: AND jstl.primary_registration_no = p_regn_no

Line 1082: FROM JAI_RGM_DEFINITIONS

1078: IS
1079:
1080: CURSOR C_REGIME_CODE IS
1081: SELECT REGIME_CODE
1082: FROM JAI_RGM_DEFINITIONS
1083: WHERE REGIME_ID = P_REGIME_ID;
1084: -- LD_TRX_DATE DATE; /*commented by ssawant for bug 5662296*/
1085: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1086:

Line 1085: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1081: SELECT REGIME_CODE
1082: FROM JAI_RGM_DEFINITIONS
1083: WHERE REGIME_ID = P_REGIME_ID;
1084: -- LD_TRX_DATE DATE; /*commented by ssawant for bug 5662296*/
1085: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1086:
1087:
1088: BEGIN
1089:

Line 1166: FROM JAI_RGM_DEFINITIONS

1162: -- for TCS
1163:
1164: CURSOR CUR_REGIME_CODE(CP_REGIME_ID NUMBER)
1165: IS SELECT REGIME_CODE
1166: FROM JAI_RGM_DEFINITIONS
1167: WHERE REGIME_ID = CP_REGIME_ID;
1168: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1169:
1170:

Line 1168: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1164: CURSOR CUR_REGIME_CODE(CP_REGIME_ID NUMBER)
1165: IS SELECT REGIME_CODE
1166: FROM JAI_RGM_DEFINITIONS
1167: WHERE REGIME_ID = CP_REGIME_ID;
1168: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1169:
1170:
1171:
1172: BEGIN

Line 1332: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

1328: ln_cess_debit_amt NUMBER;
1329: ln_discounted_amt NUMBER;
1330: ln_charge_account_id NUMBER;
1331: ln_cess_amount NUMBER;
1332: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
1333: ln_charge_accounting_id NUMBER;
1334: ln_balance_accounting_id NUMBER;
1335: ln_credit_amount NUMBER;
1336: ln_debit_amount NUMBER;