APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on AP_LOOKUP_CODES

Line 901: --* : ap_lookup_codes SELECT *--

897: --* Tables Used : ap_invoices_interface SELECT *--
898: --* : ap_invoice_lines_interface SELECT *--
899: --* : ap_interface_rejections SELECT *--
900: --* : fv_ipac_import SELECT, UPDATE *--
901: --* : ap_lookup_codes SELECT *--
902: --* Logic : Go through ap_interface_rejections for the group id and see *--
903: --* : if there are any header errors. If so insert the errors into *--
904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
905: --* : error status. *--

Line 941: ap_lookup_codes alc

937: alc.description
938: FROM ap_invoices_interface aii,
939: ap_interface_rejections air,
940: fv_ipac_import fii,
941: ap_lookup_codes alc
942: WHERE aii.group_id = p_group_id
943: AND aii.status = 'REJECTED'
944: AND aii.invoice_id = air.parent_id
945: AND air.parent_table = 'AP_INVOICES_INTERFACE'

Line 1014: ap_lookup_codes alc

1010: FROM ap_invoices_interface aii,
1011: ap_invoice_lines_interface aili,
1012: ap_interface_rejections air,
1013: fv_ipac_import fii,
1014: ap_lookup_codes alc
1015: WHERE aii.group_id = p_group_id
1016: AND aii.status = 'REJECTED'
1017: AND aili.invoice_line_id = air.parent_id
1018: AND aii.invoice_id = aili.invoice_id