DBA Data[Home] [Help]

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 564: FROM pa_rep_org_util_v

560: x_org_id := NULL;
561: IF (p_calling_mode = 'ORG') THEN
562: SELECT distinct parent_organization_id
563: INTO x_org_id
564: FROM pa_rep_org_util_v
565: WHERE parent_org_name = p_org_name;
566: END IF;
567:
568: EXCEPTION