DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_PAYMENT_UTIL_PKG

Line 998: AP_PAYMENT_UTIL_PKG.get_psr_status(IPSR.payment_service_request_id,

994: WHERE IPSR.call_app_pay_service_req_code (+) = AISC.checkrun_name
995: AND trunc(aisc.check_date) between g_period_start_date and g_period_end_date
996: AND DECODE(IPSR.payment_service_request_id, NULL,
997: AISC.status,
998: AP_PAYMENT_UTIL_PKG.get_psr_status(IPSR.payment_service_request_id,
999: IPSR.payment_service_request_status) )
1000: NOT IN ('CONFIRMED','CANCELED','QUICKCHECK', 'CANCELLED NO PAYMENTS', 'TERMINATED')
1001: AND aisc.checkrun_id = asi.checkrun_id
1002: AND asi.org_id in (select org_id org_id from ap_org_attributes_gt org_gtt)