APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_SYSTEM_PARAMETERS

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 627: -- Merge the existing SELECTs into two. One SELECT from ap_system_parameters.

623: -- P_vendor_site_id
624: -- P_base_currency_code
625: -- P_type_1099
626: -- P_income_tax_region
627: -- Merge the existing SELECTs into two. One SELECT from ap_system_parameters.
628: -- The other from ap_invoices. SELECT type_1099, income_tax_region,
629: -- and base currency and pass them back to ap_create_interest_invoice_pkg.
630:
631: -- Remove expense interest account. Not need to select it

Line 651: FROM ap_system_parameters asp,

647: P_asset_account_flag,
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

Line 1311: l_system_interest_account ap_system_parameters_all.INTEREST_CODE_COMBINATION_ID%type;

1307: l_inv_distribution_line_number number;
1308: l_distribution_total number;
1309: l_distribution_base_total number;
1310: l_account_from_ap_system CHAR(1) ;
1311: l_system_interest_account ap_system_parameters_all.INTEREST_CODE_COMBINATION_ID%type;
1312:
1313:
1314:
1315:

Line 1387: from ap_system_parameters_all

1383: -- to 1 to avoid divide by zero error
1384:
1385: select PRORATE_INT_INV_ACROSS_DISTS --start of code for bug 7112849
1386: into l_account_from_ap_system
1387: from ap_system_parameters_all
1388: where org_id = P_org_id ; -- Bug#8763764
1389:
1390: -- 8453503 added NVL in the below condition
1391:

Line 1397: from ap_system_parameters_all

1393:
1394: -- check whether PRORATE_INT_INV_ACROSS_DISTS is Y or not if it is not Y use the system account defined on payables else use the invoice account and prorate
1395: select INTEREST_CODE_COMBINATION_ID
1396: into l_system_interest_account
1397: from ap_system_parameters_all
1398: where org_id = P_org_id ; -- Bug#8763764;
1399:
1400: debug_info := 'inserting tax distribution using system defined account in ap_system_parameters';
1401: l_inv_distribution_line_number :=

Line 1400: debug_info := 'inserting tax distribution using system defined account in ap_system_parameters';

1396: into l_system_interest_account
1397: from ap_system_parameters_all
1398: where org_id = P_org_id ; -- Bug#8763764;
1399:
1400: debug_info := 'inserting tax distribution using system defined account in ap_system_parameters';
1401: l_inv_distribution_line_number :=
1402: NVL(l_inv_distribution_line_number,0) + 1;
1403: INSERT INTO AP_INVOICE_DISTRIBUTIONS_ALL --bug 9328384
1404: (INVOICE_ID,

Line 2301: FROM ap_system_parameters_all asp,

2297: --4533605, modified this for moac
2298:
2299: SELECT nvl(interest_tolerance_amount,0)
2300: INTO C_interest_tolerance_amount
2301: FROM ap_system_parameters_all asp,
2302: ap_invoices_all ai
2303: WHERE ai.org_id = asp.org_id
2304: AND ai.invoice_id = p_invoice_id;
2305: