APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on JAI_RGM_DEFINITIONS

Line 220: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

216: lv_process_status varchar2(30);
217: lv_process_message VARCHAR2(1996);
218:
219: lv_source varchar2(30);
220: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
221: ln_charge_accounting_id NUMBER;
222: ln_balance_accounting_id NUMBER;
223: ln_credit_amount NUMBER;
224: ln_debit_amount NUMBER;

Line 692: from JAI_RGM_DEFINITIONS

688: lv_regime_id jai_rgm_settlements.regime_id%type;
689:
690: cursor cur_regime_code is /*Ravi */
691: select regime_code
692: from JAI_RGM_DEFINITIONS
693: where regime_id = lv_regime_id;
694:
695: cursor cur_dist_detail IS -- This is ditribution detail sequence
696: SELECT JAI_RGM_DIS_DES_TAXES_S.nextval

Line 820: jai_rgm_definitions jrg

816: AND settlement_id =
817: (SELECT MAX(jbal.settlement_id)
818: FROM jai_rgm_stl_balances jbal,
819: jai_rgm_settlements jstl,
820: jai_rgm_definitions jrg
821: WHERE jbal.settlement_id = jstl.settlement_id
822: AND jrg.regime_id = jstl.regime_id
823: AND jrg.regime_code = 'TCS'
824: AND jstl.primary_registration_no = cp_regn_no

Line 864: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;/* Ravi*/

860: ln_credit_cnt NUMBER;
861: ln_credit_balance NUMBER;
862: ln_transfer_amt NUMBER;
863: ln_repository_id NUMBER;
864: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;/* Ravi*/
865: lv_statement NUMBER;
866: ln_dist_dtl_id NUMBER;
867: ln_acct_amount NUMBER; /* added by ssawant for bug 6020629 */
868: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type; /* added by ssawant for bug 6020629 */

Line 1634: FROM JAI_RGM_DEFINITIONS

1630: ORDER BY 1 ASC;
1631:
1632: CURSOR cur_regime_code IS /* 4245365*/
1633: SELECT regime_code,description
1634: FROM JAI_RGM_DEFINITIONS
1635: WHERE regime_id = pn_regime_id;
1636:
1637: CURSOR cur_org_io IS
1638: SELECT party_id,location_id

Line 2369: FROM JAI_RGM_DEFINITIONS

2365: AND vendor_site_id = c_vendor_site_id;
2366:
2367: CURSOR cur_regime_code IS /* 4245365*/
2368: SELECT regime_code,description
2369: FROM JAI_RGM_DEFINITIONS
2370: WHERE regime_id = pn_regime_id;
2371:
2372: CURSOR cur_org_io IS
2373: SELECT party_id,location_id

Line 2707: JAI_RGM_DEFINITIONS jr

2703: (
2704: select jstl.party_id,jstl.location_id,jstl.settlement_id from
2705: jai_rgm_stl_balances jstl,
2706: jai_rgm_Settlements jrs,
2707: JAI_RGM_DEFINITIONS jr
2708: WHERE jstl.settlement_id = jrs.settlement_id
2709: AND jrs.regime_id = jr.regime_id
2710: AND jr.regime_code = 'VAT'
2711: AND jrs.primary_registration_no = pn_regn_no -- 12996230