DBA Data[Home] [Help]

APPS.JE_GR_IE_RULE_LINES_PKG dependencies on DUAL

Line 51: SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;

47: 'JE_GR_IE_RULE_LINES_PKG.INSERT_ROW';
48:
49: debug_info := 'Get Rule Line ID from the Sequence';
50:
51: SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;
52:
53: debug_info := 'Insert row in je_gr_trnovr_rule_lines';
54:
55: INSERT INTO je_gr_trnovr_rule_lines (

Line 112: FROM DUAL

108: p_created_by,
109: p_last_update_date,
110: p_last_updated_by,
111: p_last_update_login
112: FROM DUAL
113: WHERE NOT EXISTS ( SELECT NULL
114: FROM je_gr_trnovr_rule_lines
115: WHERE trnovr_rule_id = p_rule_id
116: AND application_id = p_application_id