DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 1199: From ap_allocation_rule_lines arl

1195:
1196: /*
1197: And NOT EXISTS
1198: (Select chrg_invoice_line_number
1199: From ap_allocation_rule_lines arl
1200: Where arl.invoice_id = ail.invoice_id
1201: And arl.chrg_invoice_line_number = ail.line_number);
1202: */
1203:

Line 1540: DELETE FROM ap_allocation_rule_lines arl

1536: FROM ap_invoice_lines_all l
1537: WHERE l.invoice_id = ar.invoice_id
1538: AND l.line_number = ar.chrg_invoice_line_number);
1539:
1540: DELETE FROM ap_allocation_rule_lines arl
1541: WHERE arl.invoice_id = p_invoice_header_rec.invoice_id
1542: AND NOT EXISTS
1543: (SELECT 'y'
1544: FROM ap_invoice_lines_all l