DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 406: select object_id_to1 from pa_object_relationships

402: l_return_value VARCHAR2(80);
403:
404: CURSOR cur_obj_rel
405: IS
406: select object_id_to1 from pa_object_relationships
407: where object_id_to1 = l_element_version_id and
408: object_id_from1 = PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id)
409: and object_type_from = 'PA_STRUCTURES'
410: and relationship_type = 'S';

Line 415: FROM pa_object_relationships

411: /*
412: CURSOR cur_obj_rel
413: IS
414: SELECT 'x'
415: FROM pa_object_relationships
416: WHERE object_id_to1 = l_element_version_id and
417: rownum < 2 and
418: object_type_from = 'PA_TASKS';
419: */