APPS.AP_INVOICE_LINES_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 1883: FROM ap_allocation_rule_lines arl

1879:
1880: CURSOR c_charge_lines(c_invoice_id number,
1881: c_item_line_number number) Is
1882: SELECT ail.*
1883: FROM ap_allocation_rule_lines arl
1884: ,ap_invoice_lines_all ail
1885: WHERE arl.invoice_id = c_invoice_id
1886: AND arl.to_invoice_line_number = c_item_line_number
1887: AND arl.invoice_id = ail.invoice_id

Line 2093: from ap_allocation_rule_lines arl

2089: update ap_allocation_rules ar
2090: set status = 'PENDING'
2091: where ar.invoice_id = p_line_rec.invoice_id
2092: and exists (select arl.chrg_invoice_line_number
2093: from ap_allocation_rule_lines arl
2094: where arl.invoice_id = p_line_rec.invoice_id
2095: and arl.to_invoice_line_number = p_line_rec.line_number
2096: and arl.chrg_invoice_line_number = ar.chrg_invoice_line_number);
2097:

Line 2107: from ap_allocation_rule_lines arl

2103: update ap_invoice_lines_all ail
2104: set generate_dists = 'Y'
2105: where ail.invoice_id = p_line_rec.invoice_id
2106: and exists (select arl.chrg_invoice_line_number
2107: from ap_allocation_rule_lines arl
2108: where arl.invoice_id = p_line_rec.invoice_id
2109: and arl.to_invoice_line_number = p_line_rec.line_number
2110: and arl.chrg_invoice_line_number = ail.line_number);
2111:

Line 2145: delete from ap_allocation_rule_lines

2141: l_debug_info := 'Delete allocation rule lines';
2142: Print (l_api_name,l_debug_info);
2143: ----------------------------------------------------------------------------
2144:
2145: delete from ap_allocation_rule_lines
2146: where invoice_id = p_line_rec.invoice_id
2147: and to_invoice_line_number = p_line_rec.line_number;
2148:
2149: END IF;