DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on DUAL

Line 697: FROM DUAL;

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
697: FROM DUAL;
698:
699:
700: /* added by ssawant for bug 6020629 */
701: CURSOR c_acct_balances IS

Line 1541: FROM dual;

1537: WHERE invoice_id = pn_invoice_id;
1538:
1539: CURSOR cur_invoice_no IS
1540: SELECT jai_rgm_settlements_s1.NEXTVAL --rchandan for bug#4487676. JAI_RGM_SETTLEMENT_INVOICE_S is replaced with JAI_RGM_SETTLEMENTS_S1
1541: FROM dual;
1542:
1543: /* commented the below cursor by ssawant for bug 5879769
1544: CURSOR cur_distributions IS
1545: SELECT tax_type, debit, credit, NVL(debit,0) - NVL(credit,0) balance_amount