APPS.AP_RETRO_PRICING_PKG dependencies on AP_PPA_INVOICE_LINES_GT

Line 4323: FROM ap_ppa_invoice_lines_gt

4319: wfapproval_status,
4320: pa_quantity,
4321: nvl(created_by,5),
4322: nvl(creation_date,sysdate)
4323: FROM ap_ppa_invoice_lines_gt
4324: WHERE instruction_id = p_instruction_id
4325: AND adj_type = 'ADJ';
4326: --
4327: ------------------------------------------------------------------------------

Line 4531: ap_ppa_invoice_lines_gt l

4527: 'N',
4528: nvl(d.created_by,5),
4529: SYSDATE
4530: FROM ap_ppa_invoice_dists_gt d,
4531: ap_ppa_invoice_lines_gt l
4532: WHERE d.instruction_id = p_instruction_id
4533: AND d.instruction_id = l.instruction_id
4534: AND d.invoice_id = l.invoice_id
4535: AND d.invoice_line_number = l.line_number

Line 4956: FROM ap_ppa_invoice_lines_gt

4952: NULL, --receipt_conversion_amount
4953: NULL, --receipt_currency_code
4954: NULL --country_of_supply
4955: --Bug6277609 ends
4956: FROM ap_ppa_invoice_lines_gt
4957: WHERE invoice_id = c_invoice_id
4958: ORDER BY line_number;
4959:
4960: l_invoice_header_rec AP_IMPORT_INVOICES_PKG.r_invoice_info_rec;

Line 5982: FROM ap_ppa_invoice_lines_gt

5978: FND_GLOBAL.prog_appl_id, --program_application_id
5979: FND_GLOBAL.conc_program_id,--program_id
5980: SYSDATE, -- program_update_date
5981: FND_GLOBAL.conc_request_id --request_id
5982: FROM ap_ppa_invoice_lines_gt
5983: WHERE instruction_id = p_instruction_id
5984: AND invoice_id = l_ppa_invoice_id
5985: AND adj_type = 'PPA';
5986: --

Line 6383: ap_ppa_invoice_lines_gt l,

6379: CURSOR po_shipments IS
6380: SELECT pd.line_location_id,
6381: SUM(d.amount)
6382: FROM ap_ppa_invoice_dists_gt d,
6383: ap_ppa_invoice_lines_gt l,
6384: po_distributions_all pd
6385: WHERE l.instruction_id = d.instruction_id
6386: AND l.adj_type = 'PPA'
6387: AND d.instruction_id = p_instruction_rec.invoice_id

Line 6400: ap_ppa_invoice_lines_gt l,

6396: d.amount,
6397: FND_GLOBAL.conc_login_id,
6398: FND_GLOBAL.conc_request_id
6399: FROM ap_ppa_invoice_dists_gt d,
6400: ap_ppa_invoice_lines_gt l,
6401: po_distributions_all pd
6402: WHERE l.instruction_id = d.instruction_id
6403: AND l.adj_type = 'PPA'
6404: AND d.instruction_id = p_instruction_rec.invoice_id

Line 6777: ||'ap_ppa_invoice_lines_gt';

6773: RETURNING invoice_id
6774: BULK COLLECT INTO l_invoice_id_list;
6775:
6776: debug_info := 'Import_Retroprice_Adjustments 8.2. delete from '
6777: ||'ap_ppa_invoice_lines_gt';
6778: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
6779: DELETE FROM ap_ppa_invoice_lines_gt
6780: WHERE invoice_id = l_invoice_id_list(i)
6781: AND instruction_id = p_instruction_rec.invoice_id;

Line 6779: DELETE FROM ap_ppa_invoice_lines_gt

6775:
6776: debug_info := 'Import_Retroprice_Adjustments 8.2. delete from '
6777: ||'ap_ppa_invoice_lines_gt';
6778: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
6779: DELETE FROM ap_ppa_invoice_lines_gt
6780: WHERE invoice_id = l_invoice_id_list(i)
6781: AND instruction_id = p_instruction_rec.invoice_id;
6782:
6783: debug_info := 'Import_Retroprice_Adjustments 8.3. delete from '

Line 6852: FROM ap_ppa_invoice_lines_gt l

6848: --
6849: END IF;
6850: --Bug5485084 added following loop to create events
6851: FOR invs in( SELECT distinct invoice_id
6852: FROM ap_ppa_invoice_lines_gt l
6853: WHERE l.instruction_id = p_instruction_rec.invoice_id) loop
6854:
6855: AP_Accounting_Events_Pkg.Create_Events(
6856: p_event_type => 'INVOICES',

Line 6988: ap_ppa_invoice_lines_gt l

6984: WHERE invoice_adjustment_flag = 'S'
6985: AND po_distribution_id IN (
6986: SELECT d.po_distribution_id
6987: FROM ap_ppa_invoice_dists_gt d,
6988: ap_ppa_invoice_lines_gt l
6989: WHERE l.instruction_id = d.instruction_id
6990: AND l.adj_type = 'PPA'
6991: AND d.instruction_id = p_instruction_rec.invoice_id
6992: AND d.po_distribution_id = pd.po_distribution_id);