APPS.IBY_UTILITY_PVT dependencies on AP_PAYMENT_UTIL_PKG

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

1017: AND iby.call_app_pay_service_req_code =
1018: ap.checkrun_name
1019: AND iby.payment_service_request_status IN
1020: ('PAYMENTS_CREATED','COMPLETED')
1021: AND AP_PAYMENT_UTIL_PKG.get_payment_status_flag(iby.payment_service_request_id) = 'Y')
1022: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1023:
1024: l_ret_val := l_count1;
1025: g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count := l_ret_val;

Line 1511: (AP_PAYMENT_UTIL_PKG.get_payment_status_flag(c_rec_snap.payment_service_request_id) = 'Y') THEN

1507: /* IBY Errors */
1508: /* IBY Completed */
1509: ELSIF c_rec_snap.payment_service_request_status IN ('PAYMENTS_CREATED','COMPLETED') AND
1510: (c_rec_snap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999)) AND
1511: (AP_PAYMENT_UTIL_PKG.get_payment_status_flag(c_rec_snap.payment_service_request_id) = 'Y') THEN
1512: l_completed := l_completed + 1;
1513: /* IBY Completed */
1514: END IF;
1515: END LOOP;

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

1880: AND iby.call_app_pay_service_req_code =
1881: ap.checkrun_name
1882: AND iby.payment_service_request_status IN
1883: ('PAYMENTS_CREATED','COMPLETED')
1884: AND AP_PAYMENT_UTIL_PKG.get_payment_status_flag(iby.payment_service_request_id) = 'Y')
1885: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1886:
1887: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: iby_debug_pub.add(debug_msg => 'Populated Completed PPRs ',