DBA Data[Home] [Help]

APPS.JE_GR_IE_RULES_PKG dependencies on DUAL

Line 48: SELECT je_gr_trnovr_rules_s.nextval INTO l_rule_id FROM dual;

44: 'JE_GR_IE_RULES_PKG.INSERT_ROW';
45:
46: debug_info := 'Get Rule ID from the Sequence';
47:
48: SELECT je_gr_trnovr_rules_s.nextval INTO l_rule_id FROM dual;
49:
50: debug_info := 'Insert row in je_gr_trnovr_rules';
51:
52: INSERT INTO JE_GR_TRNOVR_RULES (

Line 109: FROM DUAL

105: p_last_update_date,
106: p_last_updated_by,
107: p_last_update_login,
108: p_legal_entity_id
109: FROM DUAL
110: WHERE NOT EXISTS ( SELECT NULL
111: FROM je_gr_trnovr_rules
112: WHERE application_id = p_application_id
113: AND trnovr_rule_name = p_rule_name);