APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_APPROVERS

Line 1226: from JTF_UM_APPROVERS

1222: l_org_override varchar2 (1);
1223: --
1224: cursor approverSequenceCursor is
1225: select APPROVER_SEQ
1226: from JTF_UM_APPROVERS
1227: where APPROVER_ID = x_approverID
1228: and APPROVAL_ID = l_approvalID;
1229:
1230: cursor nextApproverInfoCursor is

Line 1232: from JTF_UM_APPROVERS a, FND_USER f

1228: and APPROVAL_ID = l_approvalID;
1229:
1230: cursor nextApproverInfoCursor is
1231: select a.APPROVER_ID, a.USER_ID, f.USER_NAME
1232: from JTF_UM_APPROVERS a, FND_USER f
1233: where a.APPROVER_SEQ > l_approverSeq
1234: and a.APPROVAL_ID = l_approvalID
1235: and a.org_party_id is null
1236: and a.EFFECTIVE_START_DATE <= sysdate

Line 1246: from JTF_UM_APPROVERS a, FND_USER f

1242: order by a.APPROVER_SEQ;
1243:
1244: cursor nextOrgApproverInfoCursor is
1245: select a.APPROVER_ID, a.USER_ID, f.USER_NAME
1246: from JTF_UM_APPROVERS a, FND_USER f
1247: where a.APPROVER_SEQ > l_approverSeq
1248: and a.APPROVAL_ID = l_approvalID
1249: and a.ORG_PARTY_ID = l_org_party_id
1250: and a.EFFECTIVE_START_DATE <= sysdate

Line 1260: from JTF_UM_APPROVERS

1256:
1257:
1258: cursor OrgApproverOverrideCursor is
1259: select 'X'
1260: from JTF_UM_APPROVERS
1261: where APPROVAL_ID = l_approvalID
1262: and ORG_PARTY_ID = l_org_party_id
1263: and EFFECTIVE_START_DATE <= sysdate
1264: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;

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

1337: if (approverSequenceCursor%notfound) then
1338: -- ERROR, can't find the approver's sequence.
1339: close approverSequenceCursor;
1340: wf_core.token ('MESSAGE', 'Cannot find the current approver (user_id = '||to_char(x_approverId)
1341: ||' approval_id ='||to_char(l_approvalId)||') in JTF_UM_APPROVERS - Data corruption.');
1342: wf_core.raise ('MISSING_APPROVER_SEQUENCE');
1343: end if;
1344: close approverSequenceCursor;
1345: end if;