DBA Data[Home] [Help]

APPS.PJI_PMV_DFLT_PARAMS_PVT dependencies on HRI_CS_ORGHRO_V

Line 209: hri_cs_orghro_v org_roll

205: SELECT org_roll.sup_org_absolute_level Lvl
206: , org_list.id id
207: , org_list.value value
208: FROM
209: hri_cs_orghro_v org_roll
210: , pji_organizations_v org_list
211: WHERE
212: org_roll.org_hierarchy_version_id = G_Org_Version_Id
213: AND org_roll.sup_organization_id = org_list.id

Line 225: 'Following views HRI_CS_ORGHRO_V,

221: WHEN NO_DATA_FOUND THEN
222: -- Bug 5086074 This check will not happen for discoverer implementation
223: IF p_Calling_Context IS NULL THEN
224: raise_application_error(-20010,
225: 'Following views HRI_CS_ORGHRO_V,
226: PJI_ORGANIZATIONS_V may contain no data. Please, verify');
227: END IF;
228: RETURN NULL; /* added for bug 6034422 */
229: END Derive_Organization_ID;