APPS.PAY_LOAD_PROCESS_FLOWS dependencies on PER_BUSINESS_GROUPS

Line 56: PER_BUSINESS_GROUPS pbg

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
59: and pp.parameter_id = pps.set_name_id
60: AND pps.business_group_id = pbg.business_group_id(+)

Line 90: from per_business_groups

86: --
87: if (p_bg_name is not null) then
88: select business_group_id
89: into l_business_group_id
90: from per_business_groups
91: where name = p_bg_name;
92: end if;
93: --
94: hr_utility.trace('After getting bg_name : '||l_business_group_id);

Line 181: per_business_groups pbg

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
183: and ppd1.parameter_def_id = pp1.parameter_def_id
184: and pp1.parameter_id = pps.set_name_id
185: and pps.set_id = psv.set_id

Line 229: from per_business_groups

225: --
226: if (p_bg_name is not null) then
227: select business_group_id
228: into l_business_group_id
229: from per_business_groups
230: where name = p_bg_name;
231: end if;
232: --
233: if(found = TRUE) then

Line 343: per_business_groups pbg

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,
343: per_business_groups pbg
344: where ppd_flow.parameter_name = p_flow_name
345: and ppd_flow.parameter_def_id = pp_flow.parameter_def_id
346: and pp_flow.parameter_id = pps_flow.set_name_id
347: and pps_flow.set_id = psv_flow.set_id

Line 403: from per_business_groups

399: --
400: if (p_bg_name is not null) then
401: select business_group_id
402: into l_business_group_id
403: from per_business_groups
404: where name = p_bg_name;
405: end if;
406: --
407: if(found = TRUE) then

Line 480: per_business_groups pbg

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
483: and pp.parameter_id = pps.set_name_id
484: and pps.set_id = ppf.set_id

Line 518: from per_business_groups

514:
515: if (p_bg_name is not null) then
516: select business_group_id
517: into l_business_group_id
518: from per_business_groups
519: where name = p_bg_name;
520: end if;
521: --
522: if(found = TRUE) then

Line 601: per_business_groups pbg

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
603: and ppd1.parameter_def_id = pp1.parameter_def_id
604: and pp1.parameter_id = pps1.set_name_id
605: and pps1.set_id = ppf.set_id

Line 654: from per_business_groups

650: --
651: if (p_bg_name is not null) then
652: select business_group_id
653: into l_business_group_id
654: from per_business_groups
655: where name = p_bg_name;
656: end if;
657: --
658: if(found = TRUE) then