eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: */
64:
65: -- Fix for the bug#12597557

Line 84: AND nvl (o3.org_information16,hr_api.g_varchar2) = 'E'))));

80: ,hr_organization_information o3
81: WHERE o.organization_id = o3.organization_id
82: AND o3.org_information_context = 'Business Group Information'
83: AND o.organization_id = p_business_group_id
84: AND nvl (o3.org_information16,hr_api.g_varchar2) = 'E'))));
85:
86:
87: --
88: end if;

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

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: */
112:
113: -- Fix for the bug#12597557

Line 132: AND nvl (o3.org_information16,hr_api.g_varchar2) = 'E'))));

128: ,hr_organization_information o3
129: WHERE o.organization_id = o3.organization_id
130: AND o3.org_information_context = 'Business Group Information'
131: AND o.organization_id = p_business_group_id
132: AND nvl (o3.org_information16,hr_api.g_varchar2) = 'E'))));
133:
134: end if;
135:
136: RETURN(l_status);

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

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
1752: end if;
1753: if g_debug then

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

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