DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on AP_PAYMENT_UTIL_PKG

Line 1001: AND AP_PAYMENT_UTIL_PKG.get_payment_status_flag(iby.payment_service_request_id) = 'Y')

997: AND iby.call_app_pay_service_req_code =
998: ap.checkrun_name
999: AND iby.payment_service_request_status IN
1000: ('PAYMENTS_CREATED')
1001: AND AP_PAYMENT_UTIL_PKG.get_payment_status_flag(iby.payment_service_request_id) = 'Y')
1002: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1003:
1004: l_ret_val := l_count1;
1005: g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count := l_ret_val;