DBA Data[Home] [Help]

APPS.MO_UTILS dependencies on PER_BUSINESS_GROUPS

Line 408: FROM per_business_groups

404: ELSIF p_org_class = 'HR_BG' THEN
405: BEGIN
406: SELECT 'Y'
407: INTO l_org_exists
408: FROM per_business_groups
409: WHERE organization_id = p_org_id
410: AND business_group_id = l_bg_id;
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN

Line 440: FROM per_business_groups

436: ELSIF p_org_class = 'HR_BG' THEN
437: BEGIN
438: SELECT 'Y'
439: INTO l_org_exists
440: FROM per_business_groups
441: WHERE organization_id = p_org_id;
442: EXCEPTION
443: WHEN NO_DATA_FOUND THEN
444: l_org_exists := 'N';

Line 476: per_business_groups bg

472: BEGIN
473: SELECT 'Y'
474: INTO l_org_exists
475: FROM per_organization_list per,
476: per_business_groups bg
477: WHERE per.organization_id = bg.organization_id
478: AND per.security_profile_id = l_security_profile_id
479: AND bg.organization_id = p_org_id;
480: EXCEPTION