DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 972: From ap_allocation_rule_lines arl

968:
969: /*
970: And NOT EXISTS
971: (Select chrg_invoice_line_number
972: From ap_allocation_rule_lines arl
973: Where arl.invoice_id = ail.invoice_id
974: And arl.chrg_invoice_line_number = ail.line_number);
975: */
976:

Line 1284: DELETE FROM ap_allocation_rule_lines arl

1280: FROM ap_invoice_lines_all l
1281: WHERE l.invoice_id = ar.invoice_id
1282: AND l.line_number = ar.chrg_invoice_line_number);
1283:
1284: DELETE FROM ap_allocation_rule_lines arl
1285: WHERE arl.invoice_id = p_invoice_header_rec.invoice_id
1286: AND NOT EXISTS
1287: (SELECT 'y'
1288: FROM ap_invoice_lines_all l