[Home] [Help]
148: l_combined_filing_flag,
149: l_income_tax_region_flag,
150: l_income_tax_region_asp,
151: l_basecur
152: FROM ap_system_parameters_all asp,
153: ap_invoices_all ai
154: WHERE ai.org_id = asp.org_id
155: and ai.invoice_id = p_invoice_id;
156:
867: s.accts_pay_code_combination_id,
868: s.party_site_id,
869: pv.party_id
870: FROM ap_tax_codes_all t,
871: ap_system_parameters_all p,
872: po_vendor_sites_all s,
873: po_vendors pv
874: WHERE t.tax_id = TaxId
875: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */
1762: l_create_invoices,
1763: l_awt_flag,
1764: l_inv_curr_code,
1765: l_org_id --4742265
1766: FROM ap_system_parameters_all asp,
1767: ap_invoices_all ai
1768: WHERE ai.org_id = asp.org_id
1769: and ai.invoice_id = p_invoice_id;
1770:
1922: SELECT invoice_id
1923: , vendor_id
1924: , payment_num
1925: FROM ap_SELECTed_invoices_all ASI,
1926: ap_system_parameters_all asp
1927: WHERE checkrun_name = l_checkrun_name
1928: AND original_invoice_id IS NULL
1929: AND asp.org_id = asi.org_id
1930: and checkrun_id = l_checkrun_id
2004: , NVL(asp.awt_include_discount_amt, 'N') include_discount_amt
2005: , asp.base_currency_code
2006: FROM ap_SELECTed_invoices_all ASI,
2007: ap_invoices_all AI,
2008: ap_system_parameters_all asp
2009: WHERE ASI.checkrun_name = l_checkrun_name
2010: AND asi.checkrun_id = l_checkrun_id
2011: AND AI.invoice_id = ASI.invoice_id
2012: AND AI.org_id = asp.org_id
3208: P_Awt_Date
3209: INTO gl_period_name,
3210: gl_awt_date
3211: FROM gl_period_statuses GPS,
3212: ap_system_parameters_all ASP
3213: WHERE GPS.application_id = 200
3214: AND GPS.set_of_books_id = ASP.set_of_books_id
3215: AND P_Awt_Date BETWEEN GPS.start_date AND GPS.END_date
3216: AND GPS.closing_status IN ('O', 'F')