APPS.JTF_UM_PARTY_MERGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

    CURSOR MERGE_CODE IS SELECT  MERGE_REASON_CODE FROM HZ_MERGE_BATCH
    WHERE BATCH_ID = P_BATCH_ID;

Line: 22

    cursor find_approval is select approval_id from jtf_um_approvers
    where org_party_id = p_from_FK_id;

Line: 71

	        UPDATE JTF_UM_APPROVERS SET EFFECTIVE_END_DATE = SYSDATE,
	        LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
	        WHERE ORG_PARTY_ID = p_from_FK_id;