DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HR_OPERATING_UNITS

Line 2722: FROM hr_operating_units ou

2718: IS
2719:
2720: CURSOR c_cust IS
2721: SELECT 1
2722: FROM hr_operating_units ou
2723: , hz_cust_acct_sites_all casa
2724: , hz_cust_site_uses_all csua
2725: , hz_parties hzp
2726: , hz_cust_accounts_all hzca

Line 2738: FROM hr_operating_units

2734:
2735: -- bug 4924483 sql id 14687576 (MJC) don't use view
2736: CURSOR c_org IS
2737: /*SELECT 1
2738: FROM hr_operating_units
2739: WHERE organization_id = p_cust_vr.org_id; */
2740: -- bug 5223014 sql id 17532992 (MJC) don't need 2nd HR_ORGANIZATION_INFORMATION O3 for identification
2741: -- (takes out MJC)
2742: SELECT 1