APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 869: --mtl_transaction_reasons.

865:
866: --******** Reason Lov ***--
867: -- should not be null for part removal. Validate if the reason code sent exists in the table
868:
869: --mtl_transaction_reasons.
870: IF ( p_x_parts_rec.removal_reason_id is null
871: and (p_x_parts_rec.operation_type='M' or p_x_parts_rec.operation_type='D')
872: )
873: THEN

Line 1149: from mtl_transaction_reasons

1145:
1146: --to get reason id if reason name is provided
1147: CURSOR ahl_reason_csr (p_reason_name in varchar2) IS
1148: select reason_id
1149: from mtl_transaction_reasons
1150: where reason_name = p_Reason_Name;
1151:
1152: --To get removal reason code if menaing is provided
1153: CURSOR ahl_removal_lookup_csr(p_meaning in varchar2) IS