APPS.PAY_RULES_DBI_PKG dependencies on FF_ROUTES

Line 82: FROM ff_routes

78: BEGIN
79: --
80: SELECT route_id
81: INTO l_route_id
82: FROM ff_routes
83: WHERE route_name = upper(p_route_name);
84: --
85: EXCEPTION WHEN NO_DATA_FOUND THEN
86: --

Line 89: INSERT INTO ff_routes

85: EXCEPTION WHEN NO_DATA_FOUND THEN
86: --
87: -- Create the route, context usages, and parameters
88: --
89: INSERT INTO ff_routes
90: (route_id,
91: route_name,
92: user_defined_flag,
93: description,

Line 101: (ff_routes_s.nextval,

97: last_update_login,
98: created_by,
99: creation_date)
100: VALUES
101: (ff_routes_s.nextval,
102: upper(p_route_name),
103: 'N',
104: p_route_description,
105: p_route_text,

Line 112: SELECT ff_routes_s.currval

108: 0,
109: 0,
110: sysdate);
111: --
112: SELECT ff_routes_s.currval
113: INTO l_route_id
114: FROM dual;
115: --
116: -- Insert any context usages