APPS.AP_DRILLDOWN_PUB_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 573: FROM ap_system_parameters asp, ap_payment_history_all aph

569: WHEN l_accounting_mode <> 'D'
570: AND p_retcode = 0
571: AND l_event_status_list(num) = 'U'
572: AND EXISTS(SELECT 1
573: FROM ap_system_parameters asp, ap_payment_history_all aph
574: WHERE asp.when_to_account_pmt = 'CLEARING ONLY'
575: --AND asp.org_id = l_org_id
576: AND asp.org_id = aph.org_id
577: AND aph.accounting_event_id = l_event_list(num)

Line 586: UPDATE AP_payment_history_all APH

582: END
583: WHERE Accounting_Event_ID = l_event_list(num);
584:
585: FORALL num in 1 .. l_event_list.COUNT
586: UPDATE AP_payment_history_all APH
587: SET APH.POSTED_FLAG = CASE WHEN l_accounting_mode <> 'D'
588: AND p_retcode <> 0
589: AND l_event_status_list(num) <> 'P'
590: THEN 'N'