APPS.HR_PERSON dependencies on HR_API

Line 61: AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));

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;
64: --
65: if p_person_type = 'CWK' then

Line 81: AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));

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;
84:
85: RETURN(l_status);

Line 1698: -- AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));

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
1701: end if;
1702: if g_debug then

Line 1735: -- AND NVL(method_of_generation_cwk_num,hr_api.g_varchar2) = 'E'))));

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
1738: if is_unique_person_number(p_person_id => p_person_id
1739: ,p_person_type => 'CWK'