APPS.HR_PERSON dependencies on PER_BUSINESS_GROUPS

Line 59: FROM per_business_groups pbg

55: AND (pp.employee_number = p_person_number
56: OR (pp.npw_number = p_person_number
57: AND EXISTS
58: (SELECT null
59: FROM per_business_groups pbg
60: WHERE pbg.business_group_id = p_business_group_id
61: AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
62: --
63: end if;

Line 79: FROM per_business_groups pbg

75: AND (pp.npw_number = p_person_number
76: OR (pp.employee_number = p_person_number
77: AND EXISTS
78: (SELECT null
79: FROM per_business_groups pbg
80: WHERE pbg.business_group_id = p_business_group_id
81: AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
82: --
83: end if;

Line 335: FROM per_business_groups pbg

331: SELECT pbg.method_of_generation_apl_num
332: , pbg.legislation_code
333: INTO l_method_of_generation
334: , l_legislation_code
335: FROM per_business_groups pbg
336: WHERE pbg.business_group_id = p_business_group_id;
337: --
338: if l_method_of_generation = 'A' then
339: if g_debug then

Line 472: FROM per_business_groups pbg

468: SELECT pbg.method_of_generation_emp_num
469: , pbg.legislation_code
470: INTO l_method_of_generation
471: , l_legislation_code
472: FROM per_business_groups pbg
473: WHERE pbg.business_group_id = p_business_group_id;
474: --
475: if l_method_of_generation = 'A' then
476: if g_debug then

Line 602: FROM per_business_groups pbg

598: , pbg.legislation_code
599: INTO l_method_of_generation
600: , l_method_of_gen_emp
601: , l_legislation_code
602: FROM per_business_groups pbg
603: WHERE pbg.business_group_id = p_business_group_id;
604: --
605: if l_method_of_generation = 'A'
606: or (l_method_of_generation = 'E' and

Line 904: from per_business_groups_perf -- #3907786 - Changed to per_business_groups_perf

900: and object_type = 'PACKAGE';
901:
902: cursor csr_leg_cod is
903: select legislation_code
904: from per_business_groups_perf -- #3907786 - Changed to per_business_groups_perf
905: where business_group_id = p_business_group_id;
906:
907: l_leg_code VARCHAR2(150);
908: -- l_cursor NUMBER;

Line 1696: -- FROM per_business_groups pbg

1692: -- AND (pp.employee_number = p_employee_number
1693: -- OR (pp.npw_number = p_employee_number
1694: -- AND EXISTS
1695: -- (SELECT null
1696: -- FROM per_business_groups pbg
1697: -- WHERE pbg.business_group_id = p_business_group_id
1698: -- AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
1699: --
1700: -- << end 2660279

Line 1733: -- FROM per_business_groups pbg

1729: -- AND (pp.npw_number = p_npw_number
1730: -- OR (pp.employee_number = p_npw_number
1731: -- AND EXISTS
1732: -- (SELECT null
1733: -- FROM per_business_groups pbg
1734: -- WHERE pbg.business_group_id = p_business_group_id
1735: -- AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
1736: -- << end delete code
1737: -- >> new code