DBA Data[Home] [Help]

APPS.IGS_EN_GEN_002 dependencies on IGS_GE_S_LOG

Line 17: -- This module extracts enrolment forms data from the IGS_GE_S_LOG_ENTRY table

13: p_message_name out NOCOPY Varchar2 )
14: RETURN BOOLEAN AS
15:
16: BEGIN -- enrp_ext_enrl_form
17: -- This module extracts enrolment forms data from the IGS_GE_S_LOG_ENTRY table
18: -- and writes it to the server host.
19: DECLARE
20:
21: -- commented for conc issue...

Line 26: FROM IGS_GE_S_LOG_ENTRY sle,

22: --cst_enrol_form CONSTANT VARCHAR2(10) := 'ENROL-FORM';
23:
24: CURSOR c_sle IS
25: SELECT sle.text
26: FROM IGS_GE_S_LOG_ENTRY sle,
27: IGS_GE_S_LOG sl
28: WHERE sl.key = p_key AND
29: sl.s_log_type = p_log_type AND
30: sle.s_log_type = sl.s_log_type AND

Line 27: IGS_GE_S_LOG sl

23:
24: CURSOR c_sle IS
25: SELECT sle.text
26: FROM IGS_GE_S_LOG_ENTRY sle,
27: IGS_GE_S_LOG sl
28: WHERE sl.key = p_key AND
29: sl.s_log_type = p_log_type AND
30: sle.s_log_type = sl.s_log_type AND
31: sle.creation_dt = sl.creation_dt