eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_APPROVALS_B

Line 343: from JTF_UM_APPROVALS_B

339: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;
340:
341: cursor approvalCursor is
342: select USE_PENDING_REQ_FLAG
343: from JTF_UM_APPROVALS_B
344: where APPROVAL_ID = approvalID
345: and EFFECTIVE_START_DATE <= sysdate
346: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;
347:

Line 350: from JTF_UM_APPROVALS_B

346: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;
347:
348: cursor wfApprovalCursor is
349: select WF_ITEM_TYPE
350: from JTF_UM_APPROVALS_B
351: where APPROVAL_ID = approvalID;
352: --
353:
354: begin

Line 3152: from jtf_um_approvals_b

3148: p_wf_old_item_type varchar2(8);
3149:
3150: cursor find_new_item_type is
3151: select wf_item_type
3152: from jtf_um_approvals_b
3153: where approval_id = p_new_approval_id;
3154:
3155: p_wf_new_item_type varchar2(8);
3156: p_new_item_key number;

Line 3277: from jtf_um_approvals_b

3273: p_wf_old_item_type varchar2(8);
3274:
3275: cursor find_new_item_type is
3276: select wf_item_type
3277: from jtf_um_approvals_b
3278: where approval_id = p_new_approval_id;
3279:
3280: p_wf_new_item_type varchar2(8);
3281: p_new_item_key number;

Line 3393: from jtf_um_approvals_b

3389: and hzr.object_id = p_org_party_id;
3390:
3391: cursor find_new_item_type is
3392: select wf_item_type
3393: from jtf_um_approvals_b
3394: where approval_id = p_new_approval_id
3395: and (effective_end_date is null
3396: or effective_end_date > sysdate);
3397: