DBA Data[Home] [Help]

APPS.INL_LANDEDCOST_PVT dependencies on INL_ASSOCIATIONS

Line 64: FROM inl_associations

60: PRAGMA EXCEPTION_INIT(LOOP_ERROR, -1436);
61: BEGIN
62: SELECT count(*)
63: INTO l_count
64: FROM inl_associations
65: WHERE ship_header_id = p_ship_header_id
66: START WITH FROM_PARENT_TABLE_NAME = P_from_parent_table_name AND FROM_PARENT_TABLE_ID = P_from_parent_table_id
67: CONNECT BY PRIOR TO_PARENT_TABLE_NAME = FROM_PARENT_TABLE_NAME AND PRIOR TO_PARENT_TABLE_ID = FROM_PARENT_TABLE_ID;
68: l_in_loop := FALSE;