APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_SCHED_RELATIONSHIPS

Line 1550: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;

1546: l_hour_uom VARCHAR2(10);
1547: l_scd_req NUMBER := 1;
1548: INVALID_PARAM_EXC EXCEPTION;
1549:
1550: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1551: l_constrained_children l_relationship_records;
1552: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1553:
1554: l_min_date DATE := null;

Line 1552: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;

1548: INVALID_PARAM_EXC EXCEPTION;
1549:
1550: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1551: l_constrained_children l_relationship_records;
1552: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1553:
1554: l_min_date DATE := null;
1555: l_max_date DATE := null;
1556: l_date DATE := null;

Line 1829: wip_sched_relationships

1825: -- find the list of constrained children
1826: IF NOT l_constrained_children%ISOPEN THEN
1827: OPEN l_constrained_children FOR
1828: select * from
1829: wip_sched_relationships
1830: where relationship_type = 1
1831: and parent_object_id = p_wip_entity_id
1832: and parent_object_type_id = 1;
1833: END IF;