APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_PPA_INVOICE_LINES_GT

Line 1199: FROM ap_ppa_invoice_lines_gt

1195: BEGIN
1196: debug_info := 'Get max_ppa_line_num';
1197: SELECT COUNT(*)
1198: INTO l_max_inv_line_num
1199: FROM ap_ppa_invoice_lines_gt
1200: WHERE invoice_id = P_invoice_id;
1201:
1202: RETURN (l_max_inv_line_num);
1203:

Line 1283: FROM ap_ppa_invoice_lines_gt L

1279: debug_info VARCHAR2(1000);
1280: BEGIN
1281: SELECT NVL(SUM(amount), 0)
1282: INTO l_invoice_amount
1283: FROM ap_ppa_invoice_lines_gt L
1284: WHERE L.invoice_id = P_invoice_id;
1285: -- AND L.adj_type = 'PPA'; bug#9573078
1286:
1287: IF l_invoice_amount <> 0 THEN

Line 1398: debug_info := 'Insert into ap_ppa_invoice_lines_gt';

1394:
1395: debug_info VARCHAR2(1000);
1396: BEGIN
1397:
1398: debug_info := 'Insert into ap_ppa_invoice_lines_gt';
1399:
1400: INSERT INTO ap_ppa_invoice_lines_gt (
1401: invoice_id,
1402: line_number,

Line 1400: INSERT INTO ap_ppa_invoice_lines_gt (

1396: BEGIN
1397:
1398: debug_info := 'Insert into ap_ppa_invoice_lines_gt';
1399:
1400: INSERT INTO ap_ppa_invoice_lines_gt (
1401: invoice_id,
1402: line_number,
1403: line_type_lookup_code,
1404: requester_id,

Line 2178: from ap_ppa_invoice_lines_gt apilg

2174: INTO l_temp_ppa_count
2175: FROM ap_ppa_invoices_gt apig
2176: WHERE instruction_id = p_instruction_id
2177: and exists(select invoice_id
2178: from ap_ppa_invoice_lines_gt apilg
2179: where apilg.invoice_id = apig.invoice_id
2180: and apilg.corrected_inv_id = p_invoice_id
2181: -- and apilg.adj_type = 'PPA' --Commented for bug#9573078
2182: and nvl(apilg.amount,0) <> 0); --Modified for bug#9573078

Line 2487: FROM ap_ppa_invoice_lines_gt

2483: BEGIN
2484: debug_info := 'Get invoice_num for the corrected invoice';
2485: SELECT line_number
2486: INTO l_line_number
2487: FROM ap_ppa_invoice_lines_gt
2488: WHERE invoice_id = p_invoice_id
2489: AND corrected_line_number = p_line_number
2490: AND match_type = 'ADJUSTMENT_CORRECTION';
2491: