APPS.HZ_MO_GLOBAL_CACHE dependencies on AR_SYSTEM_PARAMETERS

Line 142: ar_system_parameters asp

138: p_globals.address_val_t,
139: -- Bug 5002547 : Added create_reciprocal_flag
140: p_globals.reciprocal_flag_t
141: FROM gl_sets_of_books gl,
142: ar_system_parameters asp
143: WHERE gl.set_of_books_id = asp.set_of_books_id;
144:
145: END retrieve_globals;
146:

Line 371: * Populates cache from AR System Parameters for non org

367: /**
368: * PROCEDURE populate_non_org
369: *
370: * DESCRIPTION
371: * Populates cache from AR System Parameters for non org
372: * entity related columns
373: *
374: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
375: *

Line 406: FROM AR_SYSTEM_PARAMETERS_ALL

402: SELECT generate_customer_number,
403: autocash_hierarchy_id,
404: default_grouping_rule_id
405: INTO l_cust, l_autocash, l_grouping
406: FROM AR_SYSTEM_PARAMETERS_ALL
407: WHERE org_id = p_org_id;
408:
409: G_Cust_Gen_Cache.default_org := p_org_id;
410: G_Cust_Gen_Cache.generate_customer_number := l_cust;

Line 564: * 30-MAR-2006 Vivek Nama Bug 5124700 Modified query to use ar_system_parameters

560: *
561: * MODIFICATION HISTORY
562: *
563: * 24-MAR-2006 Vivek Nama Bug 5107334 Created
564: * 30-MAR-2006 Vivek Nama Bug 5124700 Modified query to use ar_system_parameters
565: */
566: PROCEDURE validate_orgid_pub_api(
567: ORG_ID IN OUT NOCOPY NUMBER,
568: ERROR_MESG_SUPPR IN VARCHAR2 DEFAULT 'N',

Line 617: ar_system_parameters s

613: l_org_id,
614: l_org_name
615: FROM
616: hr_operating_units hr,
617: ar_system_parameters s
618: WHERE
619: mo_global.check_access(hr.organization_id) = 'Y'
620: AND hr.organization_id = s.org_id
621: AND s.set_of_books_id > 0

Line 686: ar_system_parameters s

682: l_org_id,
683: l_org_name
684: FROM
685: hr_operating_units hr,
686: ar_system_parameters s
687: WHERE
688: mo_global.check_access(hr.organization_id) = 'Y'
689: AND hr.organization_id = s.org_id
690: AND s.set_of_books_id > 0