APPS.PA_REPORT_UTIL dependencies on PA_REP_ORG_UTIL_V

Line 114: FROM pa_rep_org_util_v

110: BEGIN
111: SELECT parent_organization_id,parent_org_name
112: INTO x_org_id,x_org_name
113: FROM ( SELECT DISTINCT parent_organization_id,parent_org_name
114: FROM pa_rep_org_util_v
115: ORDER BY parent_org_name )
116: WHERE ROWNUM = 1;
117:
118: EXCEPTION

Line 597: FROM pa_rep_org_util_v

593: x_org_id := NULL;
594: IF (p_calling_mode = 'ORG') THEN
595: SELECT distinct parent_organization_id
596: INTO x_org_id
597: FROM pa_rep_org_util_v
598: WHERE parent_org_name = p_org_name;
599: END IF;
600:
601: EXCEPTION