DBA Data[Home] [Help]

APPS.PAY_US_CONTR_DBI dependencies on FF_ROUTES_S

Line 83: select ff_routes_s.currval,

79: sequence_no,
80: parameter_name,
81: data_type,
82: route_parameter_id)
83: select ff_routes_s.currval,
84: p_sequence_no,
85: p_parameter_name,
86: p_data_type,
87: ff_route_parameters_s.nextval

Line 104: select ff_routes_s.currval,

100: insert into ff_route_context_usages
101: (route_id,
102: context_id,
103: sequence_no)
104: select ff_routes_s.currval,
105: p_context_id,
106: p_sequence_no
107: from dual;
108: end insert_route_context_usages;

Line 175: select ff_routes_s.nextval

171: AND BCONTR.coverage_type(+) = EEV2.screen_entry_value
172: AND upper(INPUTV2.name) = ''COVERAGE''';
173: --
174: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 5);
175: select ff_routes_s.nextval
176: into l_temp
177: from dual;
178: --
179: -- now do the normal insert

Line 193: values (ff_routes_s.currval,

189: last_updated_by,
190: last_update_login,
191: created_by,
192: creation_date)
193: values (ff_routes_s.currval,
194: 'US_CONTRIBUTION_VALUES',
195: 'N',
196: 'route for contribution values using benefit contributions',
197: l_text,