DBA Data[Home] [Help]

APPS.JTF_UM_ENROLLMENT_CREDENTIALS dependencies on JTF_UM_APPROVALS_B

Line 359: from jtf_um_approvals_b

355: l_usertype_status jtf_um_usertype_reg.status_code%TYPE;
356:
357: cursor get_wf_item_type is
358: select wf_item_type
359: from jtf_um_approvals_b
360: where approval_id = p_approval_id
361: and effective_start_date < sysdate
362: and nvl (effective_end_date, sysdate + 1) > sysdate;
363:

Line 392: -- get the workflow itemtype from jtf_um_approvals_b table

388: JTF_DEBUG_PUB.LOG_PARAMETERS (MODULE_NAME || '.' || METHOD_NAME,
389: 'p_approval_id=' || p_approval_id);
390:
391: end if;
392: -- get the workflow itemtype from jtf_um_approvals_b table
393: if (p_approval_id is null) then
394: -- no approval required
395: l_wf_item_type := '';
396: else