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: */

Line 107: FROM per_business_groups pbg

103: AND (pp.npw_number = p_person_number
104: OR (pp.employee_number = p_person_number
105: AND EXISTS
106: (SELECT null
107: FROM per_business_groups pbg
108: WHERE pbg.business_group_id = p_business_group_id
109: AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
110:
111: */

Line 386: FROM per_business_groups pbg

382: SELECT pbg.method_of_generation_apl_num
383: , pbg.legislation_code
384: INTO l_method_of_generation
385: , l_legislation_code
386: FROM per_business_groups pbg
387: WHERE pbg.business_group_id = p_business_group_id;
388: --
389: if l_method_of_generation = 'A' then
390: if g_debug then

Line 523: FROM per_business_groups pbg

519: SELECT pbg.method_of_generation_emp_num
520: , pbg.legislation_code
521: INTO l_method_of_generation
522: , l_legislation_code
523: FROM per_business_groups pbg
524: WHERE pbg.business_group_id = p_business_group_id;
525: --
526: if l_method_of_generation = 'A' then
527: if g_debug then

Line 653: FROM per_business_groups pbg

649: , pbg.legislation_code
650: INTO l_method_of_generation
651: , l_method_of_gen_emp
652: , l_legislation_code
653: FROM per_business_groups pbg
654: WHERE pbg.business_group_id = p_business_group_id;
655: --
656: if l_method_of_generation = 'A'
657: or (l_method_of_generation = 'E' and

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

951: and object_type = 'PACKAGE';
952:
953: cursor csr_leg_cod is
954: select legislation_code
955: from per_business_groups_perf -- #3907786 - Changed to per_business_groups_perf
956: where business_group_id = p_business_group_id;
957:
958: l_leg_code VARCHAR2(150);
959: -- l_cursor NUMBER;

Line 1747: -- FROM per_business_groups pbg

1743: -- AND (pp.employee_number = p_employee_number
1744: -- OR (pp.npw_number = p_employee_number
1745: -- AND EXISTS
1746: -- (SELECT null
1747: -- FROM per_business_groups pbg
1748: -- WHERE pbg.business_group_id = p_business_group_id
1749: -- AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
1750: --
1751: -- << end 2660279

Line 1784: -- FROM per_business_groups pbg

1780: -- AND (pp.npw_number = p_npw_number
1781: -- OR (pp.employee_number = p_npw_number
1782: -- AND EXISTS
1783: -- (SELECT null
1784: -- FROM per_business_groups pbg
1785: -- WHERE pbg.business_group_id = p_business_group_id
1786: -- AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));
1787: -- << end delete code
1788: -- >> new code