APPS.INL_SHIPMENT_PVT dependencies on INL_SHIP_LINE_GROUPS

Line 2173: FROM inl_ship_line_groups lg

2169: l_country_code_location VARCHAR2 (100);
2170:
2171: CURSOR c_ln_group IS
2172: SELECT ship_line_group_id
2173: FROM inl_ship_line_groups lg
2174: WHERE ship_header_id = p_ship_header_id
2175: ORDER BY ship_line_group_num;
2176:
2177: BEGIN

Line 4260: AND assoc.to_parent_table_name IN ('INL_SHIP_LINES','INL_SHIP_LINE_GROUPS')

4256: AND rownum <2
4257: ) )
4258:
4259: OR (pc_level = 'GROUP'
4260: AND assoc.to_parent_table_name IN ('INL_SHIP_LINES','INL_SHIP_LINE_GROUPS')
4261: AND EXISTS
4262: (SELECT 1
4263: FROM inl_matches m
4264: WHERE m.ship_header_id = assoc.ship_header_id

Line 4274: where m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

4270: (assoc.to_parent_table_name = 'INL_SHIP_LINES'
4271: AND EXISTS (
4272: select 1
4273: from inl_ship_lines sl
4274: where m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
4275: AND sl.ship_line_group_id = m.to_parent_table_id
4276: )
4277: )
4278: OR

Line 4279: (assoc.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

4275: AND sl.ship_line_group_id = m.to_parent_table_id
4276: )
4277: )
4278: OR
4279: (assoc.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
4280: AND EXISTS (
4281: select 1
4282: from inl_ship_lines sl
4283: where m.to_parent_table_name = 'INL_SHIP_LINES'

Line 4353: ELSIF C_get_level(i).to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

4349: THEN
4350: IF l_level_charge_is_applied NOT IN ('GROUP', 'ALL') THEN
4351: l_level_charge_is_applied:='LINE';
4352: END IF;
4353: ELSIF C_get_level(i).to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
4354: THEN
4355: IF l_level_charge_is_applied <> 'ALL' THEN
4356: l_level_charge_is_applied:='GROUP';
4357: END IF;