APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 836: --mtl_transaction_reasons.

832:
833: --******** Reason Lov ***--
834: -- should not be null for part removal. Validate if the reason code sent exists in the table
835:
836: --mtl_transaction_reasons.
837: IF ( p_x_parts_rec.removal_reason_id is null
838: and (p_x_parts_rec.operation_type='M' or p_x_parts_rec.operation_type='D')
839: )
840: THEN

Line 1116: from mtl_transaction_reasons

1112:
1113: --to get reason id if reason name is provided
1114: CURSOR ahl_reason_csr (p_reason_name in varchar2) IS
1115: select reason_id
1116: from mtl_transaction_reasons
1117: where reason_name = p_Reason_Name;
1118:
1119: --To get removal reason code if menaing is provided
1120: CURSOR ahl_removal_lookup_csr(p_meaning in varchar2) IS