APPS.AP_APXTRSWP_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 8: base_curr ap_system_parameters.base_currency_code%TYPE; cash_acct_flag VARCHAR2(1);

4: USER_EXIT_FAILURE EXCEPTION;
5:
6: FUNCTION get_base_curr_data RETURN BOOLEAN IS
7:
8: base_curr ap_system_parameters.base_currency_code%TYPE; cash_acct_flag VARCHAR2(1);
9: prec fnd_currencies.precision%TYPE; min_au fnd_currencies.minimum_accountable_unit%TYPE; descr fnd_currencies.description%TYPE;
10: BEGIN
11:
12: base_curr := '';

Line 561: AP_SYSTEM_PARAMETERS_ALL ASP,

557: (SELECT NVL(ASP.ORG_ID,-99)
558: FROM HR_ORGANIZATION_INFORMATION OI,
559: HR_ALL_ORGANIZATION_UNITS_TL LE,
560: HR_ALL_ORGANIZATION_UNITS_TL OU,
561: AP_SYSTEM_PARAMETERS_ALL ASP,
562: GL_SETS_OF_BOOKS SOB
563: WHERE nvl(SOB.SLA_LEDGER_CASH_BASIS_FLAG, 'N') <> 'Y'
564: AND SOB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
565: AND ASP.ORG_ID = OI.ORGANIZATION_ID

Line 648: ap_system_parameters_all asp

644: (select nvl(asp.org_id, -99)
645: from hr_organization_information oi,
646: hr_all_organization_units_tl le,
647: hr_all_organization_units_tl ou,
648: ap_system_parameters_all asp
649: where asp.accounting_method_option = 'Accrual'
650: and asp.org_id = oi.organization_id
651: and ou.organization_id = oi.organization_id
652: and oi.org_information_context =

Line 667: ap_system_parameters_all asp

663:
664: CURSOR DIST_ORG IS
665: SELECT aid.invoice_id, aid.invoice_distribution_id
666: FROM ap_invoice_distributions_all aid,
667: ap_system_parameters_all asp
668: WHERE aid.accrual_posted_flag = 'N'
669: AND asp.accounting_method_option = 'Accrual'
670: AND ((p_period_name is null and aid.accounting_date between p_from_acctg_date
671: and p_to_acctg_date)

Line 689: from ap_system_parameters_all;

685:
686:
687: select count(*)
688: into v_no_orgs
689: from ap_system_parameters_all;
690:
691:
692:
693:

Line 743: ap_system_parameters_all asp

739: (select nvl(asp.org_id, -99)
740: from hr_organization_information oi,
741: hr_all_organization_units_tl le,
742: hr_all_organization_units_tl ou,
743: ap_system_parameters_all asp
744:
745: where
746: asp.org_id = oi.organization_id
747: and ou.organization_id = oi.organization_id

Line 782: ap_system_parameters_all asp

778: (select nvl(asp.org_id, -99)
779: from hr_organization_information oi,
780: hr_all_organization_units_tl le,
781: hr_all_organization_units_tl ou,
782: ap_system_parameters_all asp
783: where
784: asp.org_id = oi.organization_id
785: and ou.organization_id = oi.organization_id
786: and oi.org_information_context =