DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_PAYMENT_UTIL_PKG

Line 1224: AP_PAYMENT_UTIL_PKG.get_psr_status(IPSR.payment_service_request_id,

1220: WHERE IPSR.call_app_pay_service_req_code (+) = AISC.checkrun_name
1221: AND trunc(aisc.check_date) between g_period_start_date and g_period_end_date
1222: AND DECODE(IPSR.payment_service_request_id, NULL,
1223: AISC.status,
1224: AP_PAYMENT_UTIL_PKG.get_psr_status(IPSR.payment_service_request_id,
1225: IPSR.payment_service_request_status) )
1226: NOT IN ('CONFIRMED','CANCELED','QUICKCHECK', 'CANCELLED NO PAYMENTS', 'TERMINATED')
1227: AND aisc.checkrun_id = asi.checkrun_id
1228: AND asi.org_id in (select org_id org_id from ap_org_attributes_gt org_gtt)