APPS.AP_INVOICE_LINES_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 1965: FROM ap_allocation_rule_lines arl

1961:
1962: CURSOR c_charge_lines(c_invoice_id number,
1963: c_item_line_number number) Is
1964: SELECT ail.*
1965: FROM ap_allocation_rule_lines arl
1966: ,ap_invoice_lines_all ail
1967: WHERE arl.invoice_id = c_invoice_id
1968: AND arl.to_invoice_line_number = c_item_line_number
1969: AND arl.invoice_id = ail.invoice_id

Line 2765: from ap_allocation_rule_lines arl

2761: update ap_allocation_rules ar
2762: set status = 'PENDING'
2763: where ar.invoice_id = p_line_rec.invoice_id
2764: and exists (select arl.chrg_invoice_line_number
2765: from ap_allocation_rule_lines arl
2766: where arl.invoice_id = p_line_rec.invoice_id
2767: and arl.to_invoice_line_number = p_line_rec.line_number
2768: and arl.chrg_invoice_line_number = ar.chrg_invoice_line_number);
2769:

Line 2779: from ap_allocation_rule_lines arl

2775: update ap_invoice_lines_all ail
2776: set generate_dists = 'Y'
2777: where ail.invoice_id = p_line_rec.invoice_id
2778: and exists (select arl.chrg_invoice_line_number
2779: from ap_allocation_rule_lines arl
2780: where arl.invoice_id = p_line_rec.invoice_id
2781: and arl.to_invoice_line_number = p_line_rec.line_number
2782: and arl.chrg_invoice_line_number = ail.line_number);
2783:

Line 3728: delete from ap_allocation_rule_lines

3724: l_debug_info := 'Delete allocation rule lines';
3725: Print (l_api_name,l_debug_info);
3726: ----------------------------------------------------------------------------
3727:
3728: delete from ap_allocation_rule_lines
3729: where invoice_id = p_line_rec.invoice_id
3730: and to_invoice_line_number = p_line_rec.line_number;
3731:
3732: END IF;