APPS.INL_TAX_PVT dependencies on INL_CHARGE_LINES

Line 1471: AND to_parent_table_name IN ('INL_SHIP_LINES', 'INL_CHARGE_LINES')

1467: p_procedure_name => l_procedure_name,
1468: p_debug_info => l_debug_info);
1469: DELETE FROM inl_associations
1470: WHERE ship_header_id = P_ship_Header_Id
1471: AND to_parent_table_name IN ('INL_SHIP_LINES', 'INL_CHARGE_LINES')
1472: AND from_parent_table_name = 'INL_TAX_LINES';
1473:
1474: DELETE FROM inl_tax_lines tl
1475: WHERE ship_header_id = P_ship_Header_Id

Line 1504: , 'CHARGE' ,'INL_CHARGE_LINES') source

1500: ,zl.last_updated_by
1501: ,zl.last_update_date
1502: ,zl.last_update_login
1503: ,DECODE(lv.source, 'SHIP_LINE' ,'INL_SHIP_LINES'
1504: , 'CHARGE' ,'INL_CHARGE_LINES') source
1505: ,oh.ship_TYPE_ID
1506: ,inl_tax_lines_s.NEXTVAL tax_line_id_s
1507: FROM zx_lines zl
1508: ,inl_ebtax_lines_v lv

Line 1627: UPDATE inl_charge_lines

1623: last_updated_by = fnd_global.user_id,
1624: last_update_date = SYSDATE
1625: WHERE ship_header_id = p_ship_header_Id;
1626:
1627: UPDATE inl_charge_lines
1628: SET tax_already_calculated_flag = 'Y',
1629: last_updated_by = fnd_global.user_id,
1630: last_update_date = SYSDATE
1631: WHERE NVL(parent_charge_line_id,charge_line_id) IN (SELECT assoc.from_parent_table_id

Line 1633: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'

1629: last_updated_by = fnd_global.user_id,
1630: last_update_date = SYSDATE
1631: WHERE NVL(parent_charge_line_id,charge_line_id) IN (SELECT assoc.from_parent_table_id
1632: FROM inl_associations assoc
1633: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
1634: AND assoc.ship_header_id = p_ship_header_id);
1635: END IF;
1636: -- logging message
1637: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,