DBA Data[Home] [Help]

APPS.BIS_MEASURE_SECURITY_PVT dependencies on FND_RESPONSIBILITY_VL

Line 287: from fnd_responsibility_vl a, bis_indicator_resps b

283: cursor sec_cursor is
284: select a.RESPONSIBILITY_ID
285: , a.RESPONSIBILITY_KEY
286: , a.RESPONSIBILITY_NAME
287: from fnd_responsibility_vl a, bis_indicator_resps b
288: where VERSION='W'
289: and start_date <= sysdate
290: and nvl(end_date, sysdate) >= sysdate
291: and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID and b.TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id

Line 764: , fnd_responsibility_vl fr

760: , fr.RESPONSIBILITY_KEY
761: from bis_indicator_resps ir
762: , fnd_user_resp_groups ur
763: , bisbv_target_levels il
764: , fnd_responsibility_vl fr
765: where ur.user_id = p_user_id
766: and ir.responsibility_id = ur.responsibility_id
767: and ir.responsibility_id = fr.responsibility_id
768: and il.target_level_id = ir.target_level_id

Line 781: , fnd_responsibility_vl fr

777: , fr.RESPONSIBILITY_KEY
778: from bis_indicator_resps ir
779: , fnd_user_resp_groups ur
780: , bisbv_target_levels il
781: , fnd_responsibility_vl fr
782: where ur.user_id = p_user_id
783: and ir.responsibility_id = ur.responsibility_id
784: and ir.responsibility_id = fr.responsibility_id
785: and il.target_level_id = ir.target_level_id

Line 798: , fnd_responsibility_vl fr

794: , fr.RESPONSIBILITY_KEY
795: from bis_indicator_resps ir
796: , fnd_user_resp_groups ur
797: , bisbv_target_levels il
798: , fnd_responsibility_vl fr
799: where ur.user_id = p_user_id
800: and ir.responsibility_id = ur.responsibility_id
801: and ir.responsibility_id = fr.responsibility_id
802: and il.target_level_id = ir.target_level_id