DBA Data[Home] [Help]

APPS.IGI_EXP_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 934: UPDATE ap_invoice_distributions apd

930: IF l_update_gl_date = 'Y' THEN
931:
932: /* shsaxena bug.2777575 START */
933:
934: UPDATE ap_invoice_distributions apd
935: SET apd.accounting_date = TRUNC(p_gl_date),
936: apd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
937: apd.last_update_date = SYSDATE,
938: apd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

Line 952: (SELECT 'x' FROM ap_invoice_distributions aid

948: apl.last_update_date = SYSDATE,
949: apl.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
950: WHERE apl.invoice_id = r_ap_invoices.invoice_id
951: AND EXISTS
952: (SELECT 'x' FROM ap_invoice_distributions aid
953: WHERE aid.invoice_id = apl.invoice_id
954: AND aid.posted_flag = 'N');
955:
956: dvjoshi bug#5905190 END */

Line 965: (SELECT 'x' FROM ap_invoice_distributions aid

961: api.last_update_date = SYSDATE,
962: api.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
963: WHERE api.invoice_id = r_ap_invoices.invoice_id
964: AND EXISTS
965: (SELECT 'x' FROM ap_invoice_distributions aid
966: WHERE aid.invoice_id = api.invoice_id
967: AND aid.posted_flag = 'N');
968:
969: /* shsaxena bug.2777575 END */