DBA Data[Home] [Help]

APPS.PAY_US_CONTR_DBI dependencies on FF_ROUTES_S

Line 84: select ff_routes_s.currval,

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

Line 105: select ff_routes_s.currval,

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

Line 176: select ff_routes_s.nextval

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

Line 194: values (ff_routes_s.currval,

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