APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_SITE_USE_BO_TBL

Line 350: x_cust_site_use_objs OUT NOCOPY HZ_CUST_SITE_USE_BO_TBL,

346: PROCEDURE get_cust_site_use_bos(
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
348: p_cust_acct_site_id IN NUMBER,
349: p_action_type IN VARCHAR2 := NULL,
350: x_cust_site_use_objs OUT NOCOPY HZ_CUST_SITE_USE_BO_TBL,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2
354: ) is

Line 590: x_cust_site_use_objs := HZ_CUST_SITE_USE_BO_TBL();

586: p_prefix=>l_debug_prefix,
587: p_msg_level=>fnd_log.level_procedure);
588: END IF;
589:
590: x_cust_site_use_objs := HZ_CUST_SITE_USE_BO_TBL();
591: open c1;
592: fetch c1 BULK COLLECT into x_cust_site_use_objs;
593: close c1;
594:

Line 933: HZ_CUST_SITE_USE_BO_TBL(),

929: WHERE
930: OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
931: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
932: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
933: HZ_CUST_SITE_USE_BO_TBL(),
934: HZ_CUST_ACCT_CONTACT_BO_TBL())
935: FROM HZ_CUST_ACCT_SITES CAS
936: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
937: OR (P_CUST_ACCT_SITE_ID IS NOT NULL