DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on MTL_TRANSACTION_REASONS

Line 184: from mtl_transaction_reasons

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

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

824:
825: -- Get Reason Id
826:
827: if (p_reason_name is not null) then
828: select reason_id into l_reason_id from mtl_transaction_reasons where reason_name = p_reason_name;
829: end if;
830:
831: -- Get resource_id, resource_code, resource_type, uom, basis_type, activity_id, activity and standard_rate_flag
832: