DBA Data[Home] [Help]

APPS.PAY_CA_DBI_ROE dependencies on DUAL

Line 55: from dual;

51: where route_name = p_route_name;
52:
53: cursor cur_ff_routes_s is
54: select ff_routes_s.nextval
55: from dual;
56:
57: l_route_id ff_routes.route_id%TYPE;
58:
59: begin

Line 135: from dual;

131: and legislation_code = 'CA';
132:
133: cursor cur_user_entity_id is
134: select ff_user_entities_s.nextval
135: from dual;
136:
137: l_user_entity_id number;
138: l_creator_type ff_user_entities.creator_type%TYPE;
139: begin

Line 219: from dual;

215: and parameter_name = p_parameter_name;
216:
217: cursor cur_route_parameters is
218: select ff_route_parameters_s.nextval
219: from dual;
220:
221: l_route_parameter_id ff_route_parameters.route_parameter_id%TYPE;
222: begin
223: