DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on MTL_TRANSACTION_REASONS

Line 188: from mtl_transaction_reasons

184:
185:
186: CURSOR c_reason_cur IS -- rhshriva
187: select reason_name
188: from mtl_transaction_reasons
189: where nvl(disable_date, sysdate + 1) > sysdate;
190:
191: -- Cursor to fetch if resource seq num corresponding to resource_id.
192: CURSOR c_resource_seq_num IS

Line 761: select reason_id into l_reason_id from mtl_transaction_reasons where reason_name = p_reason_name;

757:
758: -- Get Reason Id
759:
760: if (p_reason_name is not null) then
761: select reason_id into l_reason_id from mtl_transaction_reasons where reason_name = p_reason_name;
762: end if;
763:
764: -- Get resource_id, resource_code, resource_type, uom, basis_type, activity_id, activity and standard_rate_flag
765: