DBA Data[Home] [Help]

APPS.EDR_MSCA_UTIL dependencies on EDR_ERECORDS

Line 95: FROM EDR_ESIGNATURES ESIG,EDR_ERECORDS EREC

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
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) || '%'