DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on CE_CASHFLOW_ACCT_H

Line 1389: FROM ce_cashflow_acct_h

1385: INTO l_err
1386: FROM ce_cashflows a
1387: WHERE a.trxn_reference_number = p_pay_trxn_number
1388: AND((SELECT COUNT(*)
1389: FROM ce_cashflow_acct_h
1390: WHERE cashflow_id=a.cashflow_id
1391: AND event_type ='CE_BAT_CLEARED' )<>
1392: (SELECT COUNT(*)
1393: FROM ce_cashflow_acct_h

Line 1393: FROM ce_cashflow_acct_h

1389: FROM ce_cashflow_acct_h
1390: WHERE cashflow_id=a.cashflow_id
1391: AND event_type ='CE_BAT_CLEARED' )<>
1392: (SELECT COUNT(*)
1393: FROM ce_cashflow_acct_h
1394: WHERE cashflow_id=a.cashflow_id
1395: AND event_type ='CE_BAT_UNCLEARED'
1396: ));
1397: IF(l_err>=1) THEN