APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on JAI_RGM_DEFINITIONS

Line 118: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

114: lv_process_status varchar2(30);
115: lv_process_message VARCHAR2(1996);
116:
117: lv_source varchar2(30);
118: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
119: ln_charge_accounting_id NUMBER;
120: ln_balance_accounting_id NUMBER;
121: ln_credit_amount NUMBER;
122: ln_debit_amount NUMBER;

Line 394: from JAI_RGM_DEFINITIONS

390: lv_regime_id jai_rgm_settlements.regime_id%type;
391:
392: cursor cur_regime_code is /*Ravi */
393: select regime_code
394: from JAI_RGM_DEFINITIONS
395: where regime_id = lv_regime_id;
396:
397: cursor cur_dist_detail IS -- This is ditribution detail sequence
398: SELECT JAI_RGM_DIS_DES_TAXES_S.nextval

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

511: ln_credit_cnt NUMBER;
512: ln_credit_balance NUMBER;
513: ln_transfer_amt NUMBER;
514: ln_repository_id NUMBER;
515: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%type;/* Ravi*/
516: lv_statement NUMBER;
517: ln_dist_dtl_id NUMBER;
518: ln_acct_amount NUMBER; /* added by ssawant for bug 6020629 */
519: ln_charge_accounting_id jai_rgm_trx_records.charge_account_id%type; /* added by ssawant for bug 6020629 */

Line 1069: FROM JAI_RGM_DEFINITIONS

1065: ORDER BY 1 ASC;
1066:
1067: CURSOR cur_regime_code IS /* 4245365*/
1068: SELECT regime_code,description
1069: FROM JAI_RGM_DEFINITIONS
1070: WHERE regime_id = pn_regime_id;
1071:
1072: CURSOR cur_org_io IS
1073: SELECT party_id,location_id

Line 1761: FROM JAI_RGM_DEFINITIONS

1757: AND vendor_site_id = c_vendor_site_id;
1758:
1759: CURSOR cur_regime_code IS /* 4245365*/
1760: SELECT regime_code,description
1761: FROM JAI_RGM_DEFINITIONS
1762: WHERE regime_id = pn_regime_id;
1763:
1764: CURSOR cur_org_io IS
1765: SELECT party_id,location_id