DBA Data[Home] [Help]

APPS.AP_INTEREST_INVOICE_PKG dependencies on GL_CODE_COMBINATIONS

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

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

Line 652: gl_code_combinations glcc,

648: P_base_currency_code,
649: P_type_1099,
650: P_income_tax_region
651: FROM ap_system_parameters asp,
652: gl_code_combinations glcc,
653: po_vendors pv,
654: po_vendor_sites pvs
655: WHERE glcc.code_combination_id = asp.interest_code_combination_id
656: AND pv.vendor_id = P_vendor_id

Line 1945: gl_code_combinations GL,

1941: DECODE(GL.account_type, 'A', 'Y', 'N') Assets_Tracking_Flag,
1942: AID.accts_pay_code_combination_id Accts_Pay_Code_Combination_Id,
1943: AID.org_id Org_Id
1944: FROM ap_invoice_distributions AID,
1945: gl_code_combinations GL,
1946: ap_invoice_payments AIP,
1947: ap_invoice_relationships AIR,
1948: ap_lookup_codes ALC
1949: WHERE AIR.related_invoice_id = AID.invoice_id

Line 2078: gl_code_combinations gl,

2074:
2075: SELECT max(aid.distribution_line_number)
2076: INTO l_max_dist_line_num
2077: FROM ap_invoice_distributions aid,
2078: gl_code_combinations gl,
2079: ap_invoice_payments aip,
2080: ap_invoice_relationships air,
2081: ap_lookup_codes alc
2082: WHERE AIR.related_invoice_id = AID.invoice_id