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
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: