APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on AP_INVOICES_ALL

Line 41: FROM ap_invoices_all

37: SELECT payment_currency_code,
38: exchange_rate,
39: exchange_date,
40: exchange_rate_type
41: FROM ap_invoices_all
42: WHERE invoice_id = cp_invoice_id;
43:
44: CURSOR c_repo_recovered_amt(cp_source IN VARCHAR2,
45: cp_source_table_name IN VARCHAR2,

Line 74: FROM ap_invoice_distributions_all a, ap_invoices_all b

70: b.cancelled_date,
71: b.invoice_type_lookup_code invoice_type,
72: a.creation_date,
73: a.po_distribution_id
74: FROM ap_invoice_distributions_all a, ap_invoices_all b
75: WHERE a.invoice_id = b.invoice_id
76: AND invoice_distribution_id = cp_invoice_distribution_id;
77:
78: PROCEDURE get_org_location(p_invoice_id IN NUMBER,

Line 227: FROM ap_invoices_all aia, jai_ap_invoice_lines jail

223: AND pll.line_location_id = pda.line_location_id
224: AND pll.ship_to_organization_id = pn_organization_id)
225: UNION
226: SELECT aia.invoice_id
227: FROM ap_invoices_all aia, jai_ap_invoice_lines jail
228: WHERE aia.invoice_id = jail.invoice_id
229: AND jail.organization_id = pn_organization_id)
230: AND jrtr.SOURCE = jai_constants.source_ap
231: AND jrtr.invoice_id = ainvd.invoice_id

Line 669: FROM ap_invoices_all

665: exchange_date,
666: exchange_rate,
667: exchange_rate_type,
668: invoice_date
669: FROM ap_invoices_all
670: WHERE invoice_id = pn_invoice_id;
671:
672: CURSOR get_dist_line_cur IS
673: SELECT ap_dist.invoice_distribution_id,

Line 725: FROM ap_invoice_distributions_all a, ap_invoices_all b

721: b.cancelled_date,
722: b.invoice_type_lookup_code invoice_type,
723: a.creation_date,
724: a.po_distribution_id
725: FROM ap_invoice_distributions_all a, ap_invoices_all b
726: WHERE a.invoice_id = b.invoice_id
727: AND invoice_distribution_id = cp_invoice_distribution_id;
728:
729: CURSOR c_reference(cp_source IN VARCHAR2,

Line 1712: FROM AP_INVOICES_ALL

1708: WHERE settlement_id = p_source_document_id;
1709:
1710: CURSOR get_inv_num_ap IS
1711: SELECT INVOICE_NUM
1712: FROM AP_INVOICES_ALL
1713: WHERE invoice_id = p_invoice_id;
1714:
1715: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
1716: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

Line 1715: lv_invoice_num ap_invoices_all.invoice_num%TYPE;

1711: SELECT INVOICE_NUM
1712: FROM AP_INVOICES_ALL
1713: WHERE invoice_id = p_invoice_id;
1714:
1715: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
1716: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
1717: lv_invoice_num_str VARCHAR2(300);
1718:
1719:

Line 1716: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

1712: FROM AP_INVOICES_ALL
1713: WHERE invoice_id = p_invoice_id;
1714:
1715: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
1716: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
1717: lv_invoice_num_str VARCHAR2(300);
1718:
1719:
1720: lv_source jai_rgm_trx_records.source%TYPE ;

Line 1897: FROM ap_invoices_all

1893: SELECT payment_currency_code,
1894: exchange_rate,
1895: exchange_date,
1896: exchange_rate_type
1897: FROM ap_invoices_all
1898: WHERE invoice_id = pn_invoice_id;
1899:
1900: CURSOR c_get_repository_flag ( pn_settlement_id NUMBER, pn_reference_id NUMBER,pn_invoice_id NUMBER, pn_invoice_line_id NUMBER, pn_tax_id NUMBER) IS
1901: SELECT 'Y'