APPS.PAY_LOAD_PROCESS_FLOWS dependencies on PAY_PARA_SET_OVERRIDE_VARS

Line 311: -- Procedure used to upload seed data for the table PAY_PARA_SET_OVERRIDE_VARS

307: -- |-----------------------< load_para_set_override_vars >---------------------|
308: -- ----------------------------------------------------------------------------
309: --
310: -- Description:
311: -- Procedure used to upload seed data for the table PAY_PARA_SET_OVERRIDE_VARS
312: --
313: -- ----------------------------------------------------------------------------
314: procedure load_para_set_override_vars
315: ( p_flow_name in varchar2

Line 330: from pay_para_set_override_vars psov,

326: ,p_set_name varchar2
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,

Line 425: INSERT INTO PAY_PARA_SET_OVERRIDE_VARS (

421: close get_src_dstn_set_var_id;
422:
423: hr_utility.trace('After get_dest_id :'|| l_destin_set_var_id);
424:
425: INSERT INTO PAY_PARA_SET_OVERRIDE_VARS (
426: shared_variable_id
427: , source_set_var_id
428: , destin_set_var_id
429: , business_group_id

Line 437: PAY_PARA_SET_OVERRIDE_VARS_S.nextval

433: ,LAST_UPDATE_LOGIN
434: ,CREATION_DATE
435: ,CREATED_BY )
436: VALUES (
437: PAY_PARA_SET_OVERRIDE_VARS_S.nextval
438: , l_source_set_var_id
439: , l_destin_set_var_id
440: , l_business_group_id
441: , p_leg_code