DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on BIS_OPERATING_UNITS_V

Line 851: (SELECT id from bis_operating_units_v

847: SELECT organization_id
848: FROM hr_operating_units
849: WHERE name = p_oper_unit_name
850: and organization_id IN
851: (SELECT id from bis_operating_units_v
852: WHERE responsibility_id IN
853: (SELECT responsibility_id
854: FROM fnd_user_resp_groups
855: WHERE user_id = FND_GLOBAL.user_id

Line 916: (SELECT id FROM bis_operating_units_v

912: SELECT organization_id
913: FROM hr_operating_units
914: WHERE name = p_oper_unit_name
915: and organization_id IN
916: (SELECT id FROM bis_operating_units_v
917: WHERE responsibility_id IN
918: (SELECT responsibility_id
919: FROM fnd_user_resp_groups
920: WHERE user_id = FND_GLOBAL.user_id