APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_APPROVERS

Line 1234: from JTF_UM_APPROVERS

1230: l_org_override varchar2 (1);
1231: --
1232: cursor approverSequenceCursor is
1233: select APPROVER_SEQ
1234: from JTF_UM_APPROVERS
1235: where APPROVER_ID = x_approverID
1236: and APPROVAL_ID = l_approvalID;
1237:
1238: cursor nextApproverInfoCursor is

Line 1240: from JTF_UM_APPROVERS a, FND_USER f

1236: and APPROVAL_ID = l_approvalID;
1237:
1238: cursor nextApproverInfoCursor is
1239: select a.APPROVER_ID, a.USER_ID, f.USER_NAME
1240: from JTF_UM_APPROVERS a, FND_USER f
1241: where a.APPROVER_SEQ > l_approverSeq
1242: and a.APPROVAL_ID = l_approvalID
1243: and a.org_party_id is null
1244: and a.EFFECTIVE_START_DATE <= sysdate

Line 1254: from JTF_UM_APPROVERS a, FND_USER f

1250: order by a.APPROVER_SEQ;
1251:
1252: cursor nextOrgApproverInfoCursor is
1253: select a.APPROVER_ID, a.USER_ID, f.USER_NAME
1254: from JTF_UM_APPROVERS a, FND_USER f
1255: where a.APPROVER_SEQ > l_approverSeq
1256: and a.APPROVAL_ID = l_approvalID
1257: and a.ORG_PARTY_ID = l_org_party_id
1258: and a.EFFECTIVE_START_DATE <= sysdate

Line 1268: from JTF_UM_APPROVERS a,

1264:
1265:
1266: cursor OrgApproverOverrideCursor is
1267: select 'X'
1268: from JTF_UM_APPROVERS a,
1269: FND_USER f
1270: where a.APPROVAL_ID = l_approvalID
1271: and a.ORG_PARTY_ID = l_org_party_id
1272: and a.EFFECTIVE_START_DATE <= sysdate

Line 1353: ||' approval_id ='||to_char(l_approvalId)||') in JTF_UM_APPROVERS - Data corruption.');

1349: if (approverSequenceCursor%notfound) then
1350: -- ERROR, can't find the approver's sequence.
1351: close approverSequenceCursor;
1352: wf_core.token ('MESSAGE', 'Cannot find the current approver (user_id = '||to_char(x_approverId)
1353: ||' approval_id ='||to_char(l_approvalId)||') in JTF_UM_APPROVERS - Data corruption.');
1354: wf_core.raise ('MISSING_APPROVER_SEQUENCE');
1355: end if;
1356: close approverSequenceCursor;
1357: end if;