APPS.PA_ORG dependencies on PA_IMP

Line 31: from pa_implementations_all pai

27:
28: dummy1 VARCHAR2(4); -- into arg for main SELECT
29: cursor check_org_structure_exists is
30: select 'X'
31: from pa_implementations_all pai
32: where ( (p_org_structure_id = pai.organization_structure_id)
33: OR (p_org_structure_id = pai.proj_org_structure_id)
34: OR (p_org_structure_id = pai.exp_org_structure_id)
35: );

Line 40: IF (pa_imp.pa_implemented_all) THEN

36: BEGIN
37: --
38: -- hr_utility.set_location('PA_ORG.PA_OS_PREDEL_VALIDATION', 1);
39: --
40: IF (pa_imp.pa_implemented_all) THEN
41:
42: -- Check if the Org Structure being deleted
43: -- is used in PA Implementations
44: --

Line 43: -- is used in PA Implementations

39: --
40: IF (pa_imp.pa_implemented_all) THEN
41:
42: -- Check if the Org Structure being deleted
43: -- is used in PA Implementations
44: --
45: open check_org_structure_exists;
46: fetch check_org_structure_exists into dummy1;
47: if check_org_structure_exists%found then

Line 106: from pa_implementations_all pai

102: --
103: dummy1 VARCHAR2(4); -- into arg for main SELECT
104: cursor check_org_structure_ver_exists is
105: select 'X'
106: from pa_implementations_all pai
107: where ( (p_org_structure_version_id = pai.org_structure_version_id)
108: OR (p_org_structure_version_id = pai.proj_org_structure_version_id)
109: OR (p_org_structure_version_id = pai.exp_org_structure_version_id)
110: );

Line 115: IF (pa_imp.pa_implemented_all) THEN

111: BEGIN
112: --
113: -- hr_utility.set_location('PA_ORG.PA_OSV_PREDEL_VALIDATION', 1);
114: --
115: IF (pa_imp.pa_implemented_all) THEN
116: --
117: -- Check if this Org Struct Version is not in the OSV
118: -- named in PA_Implementations
119: --

Line 118: -- named in PA_Implementations

114: --
115: IF (pa_imp.pa_implemented_all) THEN
116: --
117: -- Check if this Org Struct Version is not in the OSV
118: -- named in PA_Implementations
119: --
120: open check_org_structure_ver_exists;
121: fetch check_org_structure_ver_exists into dummy1;
122: if check_org_structure_ver_exists%found then

Line 183: FROM pa_implementations_all pai,

179: --
180: cursor check_start_org_exists is
181: (
182: SELECT 'X'
183: FROM pa_implementations_all pai,
184: per_org_structure_elements ose
185: WHERE p_org_structure_element_id = ose.org_structure_element_id /*Start-Added for bug:8285339*/
186: AND ((pai.org_structure_version_id = ose.org_structure_version_id
187: AND pai.start_organization_id = ose.organization_id_child)

Line 207: IF (pa_imp.pa_implemented_all) THEN

203: -- hr_utility.trace('START - pa_ose_predel_validation');
204: --
205: -- hr_utility.set_location('PA_ORG.PA_OSE_PREDEL_VALIDATION',1);
206: --
207: IF (pa_imp.pa_implemented_all) THEN
208: --
209: -- Check if this Element is the starting org specified in
210: -- PA_Implementations for Reports, '
211:

Line 210: -- PA_Implementations for Reports, '

206: --
207: IF (pa_imp.pa_implemented_all) THEN
208: --
209: -- Check if this Element is the starting org specified in
210: -- PA_Implementations for Reports, '
211:
212: open check_start_org_exists;
213: fetch check_start_org_exists into dummy1;
214: if check_start_org_exists%found then