50:
51: cursor ppsexists(p_set_name varchar2) is
52: select pps.set_id
53: from pay_parameter_sets pps,
54: pay_parameters pp,
55: pay_parameter_definitions ppd,
56: PER_BUSINESS_GROUPS pbg
57: where ppd.parameter_name = p_set_name
58: and ppd.parameter_def_id = pp.parameter_def_id
62: and nvl(pps.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;
63:
64: cursor c_get_set_name_id (p_set_name varchar2) IS
65: select pp.parameter_id
66: from PAY_PARAMETERS pp,
67: PAY_PARAMETER_DEFINITIONS ppd
68: where ppd.parameter_name = p_set_name
69: and ppd.parameter_def_id = pp.parameter_def_id;
70: --
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,
180: pay_parameter_definitions ppd2,
181: per_business_groups pbg
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,
180: pay_parameter_definitions ppd2,
181: per_business_groups pbg
182: where ppd1.parameter_name = p_set_name
192: and nvl(psv.legislation_code,'CORE') = nvl(p_leg_code,'CORE') ;
193:
194: cursor get_param_id( l_parameter_name in varchar2) is
195: select pp.parameter_id
196: from pay_parameters pp,
197: pay_parameter_definitions ppd
198: where ppd.parameter_name = l_parameter_name
199: and ppd.parameter_def_id = pp.parameter_def_id;
200:
199: and ppd.parameter_def_id = pp.parameter_def_id;
200:
201: cursor c_get_set_id ( p_set_name in varchar2 ) IS
202: select pps.set_id
203: from PAY_PARAMETERS pp,
204: PAY_PARAMETER_DEFINITIONS ppd,
205: pay_parameter_sets pps
206: where ppd.parameter_name = p_set_name
207: and ppd.parameter_def_id = pp.parameter_def_id
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,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_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,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
333: pay_parameter_sets pps_flow,
334: pay_parameter_sets pps_set,
335: pay_parameters pp_flow,
336: pay_parameters pp_flow_param,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
341: pay_parameter_definitions ppd_set,
334: pay_parameter_sets pps_set,
335: pay_parameters pp_flow,
336: pay_parameters pp_flow_param,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
341: pay_parameter_definitions ppd_set,
342: pay_parameter_definitions ppd_set_param,
363:
364: cursor get_src_dstn_set_var_id( p_flow_or_set_name varchar2,
365: p_param_name in varchar2) is
366: select psv.set_variable_id
367: from pay_parameters pp1,
368: pay_parameters pp2,
369: pay_parameter_definitions ppd1,
370: pay_parameter_definitions ppd2,
371: pay_parameter_sets pps,
364: cursor get_src_dstn_set_var_id( p_flow_or_set_name varchar2,
365: p_param_name in varchar2) is
366: select psv.set_variable_id
367: from pay_parameters pp1,
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
474: cursor ppfexists(p_flow_name varchar2) is
475: select ppf.process_flow_id
476: from pay_process_flows ppf,
477: pay_parameter_sets pps,
478: pay_parameters pp,
479: pay_parameter_definitions ppd,
480: per_business_groups pbg
481: where ppd.parameter_name = p_flow_name
482: and ppd.parameter_def_id = pp.parameter_def_id
487: and nvl(ppf.legislation_code,'CORE') = nvl(p_leg_code,'CORE');
488:
489: cursor c_get_set_id ( flow_name in varchar2 ) IS
490: select pps.set_id
491: from PAY_PARAMETERS pp,
492: PAY_PARAMETER_DEFINITIONS ppd,
493: pay_parameter_sets pps
494: where ppd.parameter_name = flow_name
495: and ppd.parameter_def_id = pp.parameter_def_id
593: from pay_process_flow_sets pfs,
594: pay_process_flows ppf,
595: pay_parameter_sets pps1,
596: pay_parameter_sets pps2,
597: pay_parameters pp1,
598: pay_parameters pp2,
599: pay_parameter_definitions ppd1,
600: pay_parameter_definitions ppd2,
601: per_business_groups pbg
594: pay_process_flows ppf,
595: pay_parameter_sets pps1,
596: pay_parameter_sets pps2,
597: pay_parameters pp1,
598: pay_parameters pp2,
599: pay_parameter_definitions ppd1,
600: pay_parameter_definitions ppd2,
601: per_business_groups pbg
602: where ppd1.parameter_name = p_flow_name
615: cursor c_get_flow_id ( p_flow_name in varchar2 ) IS
616: select ppf.process_flow_id
617: from pay_process_flows ppf,
618: pay_parameter_sets pps,
619: PAY_PARAMETERS pp,
620: PAY_PARAMETER_DEFINITIONS ppd
621: where ppd.parameter_name = p_flow_name
622: and ppd.parameter_def_id = pp.parameter_def_id
623: and pp.parameter_id = pps.set_name_id
624: and pps.set_id = ppf.set_id;
625:
626: cursor c_get_set_id ( p_set_name in varchar2 ) IS
627: select pps.set_id
628: from PAY_PARAMETERS pp,
629: PAY_PARAMETER_DEFINITIONS ppd,
630: pay_parameter_sets pps
631: where ppd.parameter_name = p_set_name
632: and ppd.parameter_def_id = pp.parameter_def_id