APPS.JTF_UM_PARTY_MERGE dependencies on JTF_UM_APPROVERS

Line 22: cursor find_approval is select approval_id from jtf_um_approvers

18: CURSOR MERGE_CODE IS SELECT MERGE_REASON_CODE FROM HZ_MERGE_BATCH
19: WHERE BATCH_ID = P_BATCH_ID;
20: p_merge_code VARCHAR2(30);
21:
22: cursor find_approval is select approval_id from jtf_um_approvers
23: where org_party_id = p_from_FK_id;
24:
25: p_approval_id number;
26:

Line 62: /* End Date all the approvers in JTF_UM_APPROVERS table, who

58: */
59:
60: if p_from_FK_id <> p_to_FK_id then
61:
62: /* End Date all the approvers in JTF_UM_APPROVERS table, who
63: belonged to previous org
64: */
65: open find_approval;
66: fetch find_approval into p_approval_id;

Line 71: UPDATE JTF_UM_APPROVERS SET EFFECTIVE_END_DATE = SYSDATE,

67: close find_approval;
68:
69: if p_approval_id is not null then
70:
71: UPDATE JTF_UM_APPROVERS SET EFFECTIVE_END_DATE = SYSDATE,
72: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
73: WHERE ORG_PARTY_ID = p_from_FK_id;
74:
75: -- Call procedure to restart workflow