APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_SECURITY_GROUPS

Line 3387: from fnd_security_groups_vl

3383: where security_profile_name = cp_security_profile_name;
3384:
3385: cursor csr_security_group_name(cp_security_group_id in number) IS
3386: select security_group_name,security_group_key
3387: from fnd_security_groups_vl
3388: where security_group_id = cp_security_group_id;
3389:
3390: l_user_name fnd_user.user_name%type;
3391: l_security_group_id fnd_security_groups.security_group_id%type;

Line 3391: l_security_group_id fnd_security_groups.security_group_id%type;

3387: from fnd_security_groups_vl
3388: where security_group_id = cp_security_group_id;
3389:
3390: l_user_name fnd_user.user_name%type;
3391: l_security_group_id fnd_security_groups.security_group_id%type;
3392: l_business_group_id per_business_groups.business_group_id%type;
3393: l_business_group_name per_business_groups.name%type;
3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;

Line 3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;

3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
3397:
3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;
3399: l_security_group_key fnd_security_groups_vl.security_group_key%type;
3400: l_application_short_name fnd_application.application_short_name%type;
3401:
3402: l_security_profile_name per_business_groups.name%type;

Line 3399: l_security_group_key fnd_security_groups_vl.security_group_key%type;

3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
3397:
3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;
3399: l_security_group_key fnd_security_groups_vl.security_group_key%type;
3400: l_application_short_name fnd_application.application_short_name%type;
3401:
3402: l_security_profile_name per_business_groups.name%type;
3403: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;