DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on DUAL

Line 399: FROM DUAL;

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
399: FROM DUAL;
400:
401:
402: /* added by ssawant for bug 6020629 */
403: CURSOR c_acct_balances IS

Line 1016: FROM dual;

1012: WHERE invoice_id = pn_invoice_id;
1013:
1014: CURSOR cur_invoice_no IS
1015: SELECT jai_rgm_settlements_s1.NEXTVAL --rchandan for bug#4487676. JAI_RGM_SETTLEMENT_INVOICE_S is replaced with JAI_RGM_SETTLEMENTS_S1
1016: FROM dual;
1017:
1018: /* commented the below cursor by ssawant for bug 5879769
1019: CURSOR cur_distributions IS
1020: SELECT tax_type, debit, credit, NVL(debit,0) - NVL(credit,0) balance_amount