APPS.EDR_MSCA_UTIL dependencies on EDR_UTILITIES

Line 92: Select EDR_UTILITIES.GETUSERDISPLAYNAME(ESIG.USER_NAME) USER_DISPLAY_NAME,

88:
89: BEGIN
90: --Obtain the approver list.
91: OPEN x_approvers FOR
92: Select EDR_UTILITIES.GETUSERDISPLAYNAME(ESIG.USER_NAME) USER_DISPLAY_NAME,
93: ESIG.SIGNATURE_SEQUENCE,
94: ESIG.USER_NAME
95: FROM EDR_ESIGNATURES ESIG,EDR_ERECORDS EREC
96: where EREC.EVENT_ID=ESIG.EVENT_ID

Line 99: and UPPER(EDR_UTILITIES.GETUSERDISPLAYNAME(ESIG.USER_NAME)) like UPPER(p_approverName) || '%'

95: FROM EDR_ESIGNATURES ESIG,EDR_ERECORDS EREC
96: where EREC.EVENT_ID=ESIG.EVENT_ID
97: and ESIG.EVENT_ID = p_eventkey
98: and ESIG.SIGNATURE_STATUS = 'PENDING'
99: and UPPER(EDR_UTILITIES.GETUSERDISPLAYNAME(ESIG.USER_NAME)) like UPPER(p_approverName) || '%'
100: order by SIGNATURE_SEQUENCE;
101:
102: END GET_APPROVERS;
103: