APPS.IBY_IMPORT_PMT_ACK_DATA_PUB dependencies on IBY_BANK_ACK_STATUSES

Line 67: FROM iby_bank_ack_statuses

63: CURSOR c_bank_status
64: (ci_bank_status IN iby_ack_pmt_all.bank_status_code%TYPE)
65: IS
66: SELECT count(1)
67: FROM iby_bank_ack_statuses
68: WHERE bank_ack_status_code = p_bank_status_code
69: AND nvl(trunc(inactive_date), sysdate+10 ) > trunc (sysdate);
70:
71: BEGIN

Line 104: FROM iby_bank_ack_statuses

100: CURSOR c_pmt_ack_status
101: (ci_bank_status IN iby_ack_pmt_all.bank_status_code%TYPE)
102: IS
103: SELECT payment_ack_status
104: FROM iby_bank_ack_statuses
105: WHERE bank_ack_status_code = ci_bank_status;
106:
107: BEGIN
108: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN