DBA Data[Home] [Help]

APPS.AP_INTEREST_INVOICE_PKG dependencies on GL_CODE_COMBINATIONS

Line 613: -- get some required ccid from ap_system_parameters and gl_code_combinations

609:
610: current_calling_sequence := 'ap_int_inv_get_info<-'||P_calling_sequence;
611:
612: ----------------------------------------------------------------------------
613: -- get some required ccid from ap_system_parameters and gl_code_combinations
614: ----------------------------------------------------------------------------
615:
616: -- Interest Invoices project - Invoice Lines - 11ix
617: -- Add the parameters

Line 648: gl_code_combinations glcc,

644: P_base_currency_code,
645: P_type_1099,
646: P_income_tax_region
647: FROM ap_system_parameters asp,
648: gl_code_combinations glcc,
649: po_vendors pv,
650: po_vendor_sites pvs
651: WHERE glcc.code_combination_id = asp.interest_code_combination_id
652: AND pv.vendor_id = P_vendor_id

Line 1849: gl_code_combinations GL,

1845: DECODE(GL.account_type, 'A', 'Y', 'N') Assets_Tracking_Flag,
1846: AID.accts_pay_code_combination_id Accts_Pay_Code_Combination_Id,
1847: AID.org_id Org_Id
1848: FROM ap_invoice_distributions AID,
1849: gl_code_combinations GL,
1850: ap_invoice_payments AIP,
1851: ap_invoice_relationships AIR,
1852: ap_lookup_codes ALC
1853: WHERE AIR.related_invoice_id = AID.invoice_id

Line 1982: gl_code_combinations gl,

1978:
1979: SELECT max(aid.distribution_line_number)
1980: INTO l_max_dist_line_num
1981: FROM ap_invoice_distributions aid,
1982: gl_code_combinations gl,
1983: ap_invoice_payments aip,
1984: ap_invoice_relationships air,
1985: ap_lookup_codes alc
1986: WHERE AIR.related_invoice_id = AID.invoice_id