DBA Data[Home] [Help]

APPS.PER_SEU_BUS dependencies on PER_SECURITY_PROFILES

Line 41: , per_security_profiles psp

37: select pbg.security_group_id,
38: pbg.legislation_code
39: from per_business_groups_perf pbg
40: , per_security_users seu
41: , per_security_profiles psp
42: where seu.security_user_id = p_security_user_id
43: and seu.security_profile_id = psp.security_profile_id
44: and psp.business_group_id is not null
45: and pbg.business_group_id = psp.business_group_id;

Line 125: , per_security_profiles psp

121: cursor csr_leg_code is
122: select pbg.legislation_code
123: from per_business_groups_perf pbg
124: , per_security_users seu
125: , per_security_profiles psp
126: where seu.security_user_id = p_security_user_id
127: and seu.security_profile_id = psp.security_profile_id
128: and psp.business_group_id is not null
129: and pbg.business_group_id = psp.business_group_id;

Line 347: FROM per_security_profiles psp

343: -- Verifies the security profile exists.
344: --
345: CURSOR csr_chk_sec_prof IS
346: SELECT psp.security_profile_id
347: FROM per_security_profiles psp
348: WHERE psp.security_profile_id = p_security_profile_id;
349:
350: --
351: Begin