2867: IS
2868:
2869: CURSOR c_cust IS
2870: SELECT 1
2871: FROM hr_operating_units ou
2872: , hz_cust_acct_sites_all casa
2873: , hz_cust_site_uses_all csua
2874: , hz_parties hzp
2875: , hz_cust_accounts_all hzca
2883:
2884: -- bug 4924483 sql id 14687576 (MJC) don't use view
2885: CURSOR c_org IS
2886: /*SELECT 1
2887: FROM hr_operating_units
2888: WHERE organization_id = p_cust_vr.org_id; */
2889: -- bug 5223014 sql id 17532992 (MJC) don't need 2nd HR_ORGANIZATION_INFORMATION O3 for identification
2890: -- (takes out MJC)
2891: SELECT 1