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.

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 3092: from jtf_um_approvals_b

3088: p_wf_old_item_type varchar2(8);
3089:
3090: cursor find_new_item_type is
3091: select wf_item_type
3092: from jtf_um_approvals_b
3093: where approval_id = p_new_approval_id;
3094:
3095: p_wf_new_item_type varchar2(8);
3096: p_new_item_key number;

Line 3217: from jtf_um_approvals_b

3213: p_wf_old_item_type varchar2(8);
3214:
3215: cursor find_new_item_type is
3216: select wf_item_type
3217: from jtf_um_approvals_b
3218: where approval_id = p_new_approval_id;
3219:
3220: p_wf_new_item_type varchar2(8);
3221: p_new_item_key number;

Line 3333: from jtf_um_approvals_b

3329: and hzr.object_id = p_org_party_id;
3330:
3331: cursor find_new_item_type is
3332: select wf_item_type
3333: from jtf_um_approvals_b
3334: where approval_id = p_new_approval_id
3335: and (effective_end_date is null
3336: or effective_end_date > sysdate);
3337: