DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_ACCT_CONTACT_BO_TBL

Line 934: HZ_CUST_ACCT_CONTACT_BO_TBL())

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
938: AND CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID));

Line 1680: HZ_CUST_ACCT_CONTACT_BO_TBL())

1676: OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
1677: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
1678: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
1679: HZ_CUST_SITE_USE_V2_BO_TBL(),
1680: HZ_CUST_ACCT_CONTACT_BO_TBL())
1681: FROM HZ_CUST_ACCT_SITES CAS
1682: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
1683: OR (P_CUST_ACCT_SITE_ID IS NOT NULL
1684: AND CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID));