APPS.PAY_LOAD_PROCESS_FLOWS dependencies on PAY_PARA_SET_VARIABLES

Line 175: from pay_para_set_variables psv,

171:
172: cursor psvexists( p_set_name varchar2
173: ,p_param_name varchar2) is
174: select psv.set_variable_id
175: from pay_para_set_variables psv,
176: pay_parameter_sets pps,
177: pay_parameters pp1,
178: pay_parameters pp2,
179: pay_parameter_definitions ppd1,

Line 236: UPDATE PAY_PARA_SET_VARIABLES SET

232: --
233: if(found = TRUE) then
234:
235:
236: UPDATE PAY_PARA_SET_VARIABLES SET
237: set_var_sequence = p_set_var_seq
238: , variable_type = p_var_type
239: , default_type = p_def_type
240: , default_value = p_def_value

Line 260: INSERT INTO PAY_PARA_SET_VARIABLES (

256: CLOSE c_get_set_id;
257:
258: hr_utility.trace('Before inserting, l_set_id : '||l_set_id);
259:
260: INSERT INTO PAY_PARA_SET_VARIABLES (
261: set_variable_id
262: , set_id
263: , parameter_id
264: , group_id

Line 279: PAY_PARA_SET_VARIABLES_S.nextval

275: ,LAST_UPDATE_LOGIN
276: ,CREATION_DATE
277: ,CREATED_BY )
278: VALUES (
279: PAY_PARA_SET_VARIABLES_S.nextval
280: , l_set_id
281: , l_parameter_id
282: , p_group_id
283: , p_var_type

Line 331: pay_para_set_variables psv_flow,

327: ,p_set_param varchar2
328: ) is
329: select psov.shared_variable_id
330: from pay_para_set_override_vars psov,
331: pay_para_set_variables psv_flow,
332: pay_para_set_variables psv_set,
333: pay_parameter_sets pps_flow,
334: pay_parameter_sets pps_set,
335: pay_parameters pp_flow,

Line 332: pay_para_set_variables psv_set,

328: ) is
329: select psov.shared_variable_id
330: from pay_para_set_override_vars psov,
331: pay_para_set_variables psv_flow,
332: pay_para_set_variables psv_set,
333: pay_parameter_sets pps_flow,
334: pay_parameter_sets pps_set,
335: pay_parameters pp_flow,
336: pay_parameters pp_flow_param,

Line 372: pay_para_set_variables psv

368: pay_parameters pp2,
369: pay_parameter_definitions ppd1,
370: pay_parameter_definitions ppd2,
371: pay_parameter_sets pps,
372: pay_para_set_variables psv
373: where ppd1.parameter_name = p_flow_or_set_name
374: and ppd1.parameter_def_id = pp1.parameter_def_id
375: and pp1.parameter_id = pps.set_name_id
376: and pps.set_id = psv.set_id