DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HR_OPERATING_UNITS

Line 2871: FROM hr_operating_units ou

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

Line 2887: FROM hr_operating_units

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