DBA Data[Home] [Help]

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1691: FROM hz_cust_site_uses_all csu

1687: IS
1688:
1689: CURSOR site_cur IS
1690: SELECT csu.site_use_id
1691: FROM hz_cust_site_uses_all csu
1692: WHERE csu.site_use_id = p_site_use_id
1693: AND csu.site_use_code = p_site_use_code;
1694:
1695: /* BUG # 2159414

Line 1698: FROM hz_cust_site_uses_all csu ,

1694:
1695: /* BUG # 2159414
1696: CURSOR site_cur IS
1697: SELECT csu.site_use_id
1698: FROM hz_cust_site_uses_all csu ,
1699: hz_cust_acct_sites_all cas
1700: WHERE csu.site_use_id = p_site_use_id
1701: AND csu.site_use_code = p_site_use_code
1702: AND csu.cust_acct_site_id = cas.cust_acct_site_id