APPS.AP_APXTRSWP_XMLP_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 765: UPDATE ap_payment_history_all aph

761:
762: /*srw.message('14', 'Updating payment history records ....');*/null;
763:
764:
765: UPDATE ap_payment_history_all aph
766: SET accounting_date = c_sweep_to_date,
767: last_update_date = sysdate,
768: last_updated_by = 5
769: WHERE nvl(aph.posted_flag, 'N') IN ('N','S')

Line 865: UPDATE ap_payment_history_all aph

861:
862: /*srw.message('14', 'Updating payment history records ....');*/null;
863:
864:
865: UPDATE ap_payment_history_all aph
866: SET accounting_date = c_sweep_to_date,
867: last_update_date = sysdate,
868: last_updated_by = 5
869: WHERE nvl(aph.posted_flag, 'N') IN ('N','S') AND ((p_period_name is null and accounting_date between p_from_acctg_date