DBA Data[Home] [Help]

APPS.BIS_MEASURE_SECURITY_PVT dependencies on FND_USER_RESP_GROUPS

Line 762: , fnd_user_resp_groups ur

758: , ir.Responsibility_ID
759: , fr.RESPONSIBILITY_NAME
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

Line 779: , fnd_user_resp_groups ur

775: , ir.Responsibility_ID
776: , fr.RESPONSIBILITY_NAME
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

Line 796: , fnd_user_resp_groups ur

792: , ir.Responsibility_ID
793: , fr.RESPONSIBILITY_NAME
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

Line 930: FROM fnd_user_resp_groups

926: l_error VARCHAR2(10) := FND_API.G_FALSE;
927: l_dlc_sec VARCHAR2(1);
928: CURSOR c_resp IS
929: SELECT responsibility_id
930: FROM fnd_user_resp_groups
931: WHERE user_id=p_user_id;
932: CURSOR c_indresp(p_target_level_id IN NUMBER) IS
933: SELECT responsibility_id
934: FROM bis_indicator_Resps