APPS.PERFRPHR dependencies on HR_ORGANIZATION_INFORMATION

Line 91: FROM hr_organization_information hr1,

87: per_assignment_status_types ast,
88: per_person_types_v pt,
89: per_all_people_f peo
90: WHERE asg.establishment_id IN (SELECT hr2.organization_id
91: FROM hr_organization_information hr1,
92: hr_organization_information hr2
93: WHERE hr1.organization_id = p_ent_id
94: AND hr1.org_information1 = hr2.org_information1
95: AND hr1.org_information_context = hr2.org_information_context

Line 92: hr_organization_information hr2

88: per_person_types_v pt,
89: per_all_people_f peo
90: WHERE asg.establishment_id IN (SELECT hr2.organization_id
91: FROM hr_organization_information hr1,
92: hr_organization_information hr2
93: WHERE hr1.organization_id = p_ent_id
94: AND hr1.org_information1 = hr2.org_information1
95: AND hr1.org_information_context = hr2.org_information_context
96: AND hr1.org_information_context = 'FR_ESTAB_INFO'

Line 125: FROM hr_organization_information hr1,

121: per_assignment_status_types ast2,
122: per_person_types_v pt2,
123: per_all_people_f peo2
124: WHERE asg2.establishment_id IN (SELECT hr2.organization_id
125: FROM hr_organization_information hr1,
126: hr_organization_information hr2
127: WHERE hr1.organization_id = p_ent_id
128: AND hr1.org_information1 = hr2.org_information1
129: AND hr1.org_information_context = hr2.org_information_context

Line 126: hr_organization_information hr2

122: per_person_types_v pt2,
123: per_all_people_f peo2
124: WHERE asg2.establishment_id IN (SELECT hr2.organization_id
125: FROM hr_organization_information hr1,
126: hr_organization_information hr2
127: WHERE hr1.organization_id = p_ent_id
128: AND hr1.org_information1 = hr2.org_information1
129: AND hr1.org_information_context = hr2.org_information_context
130: AND hr1.org_information_context = 'FR_ESTAB_INFO'

Line 229: FROM hr_organization_information hoi,

225: WHERE application_id = b_appl_id;
226: --
227: CURSOR c_urssaf_code (b_est_id IN NUMBER) IS
228: SELECT UPPER(hoi2.org_information1)
229: FROM hr_organization_information hoi,
230: hr_organization_information hoi2
231: WHERE hoi2.org_information_context = 'FR_URSSAF_CENTR_INFO'
232: AND hoi2.organization_id = hoi.org_information1
233: AND hoi.org_information_context = 'FR_ESTAB_URSSAF'

Line 230: hr_organization_information hoi2

226: --
227: CURSOR c_urssaf_code (b_est_id IN NUMBER) IS
228: SELECT UPPER(hoi2.org_information1)
229: FROM hr_organization_information hoi,
230: hr_organization_information hoi2
231: WHERE hoi2.org_information_context = 'FR_URSSAF_CENTR_INFO'
232: AND hoi2.organization_id = hoi.org_information1
233: AND hoi.org_information_context = 'FR_ESTAB_URSSAF'
234: AND hoi.organization_id = b_est_id;

Line 316: HR_ORGANIZATION_INFORMATION OI1,

312: per_contracts_f con,
313: per_jobs job,
314: hr_locations_all loc,
315: hr_ALL_ORGANIZATION_UNITS OU1,
316: HR_ORGANIZATION_INFORMATION OI1,
317: per_assignment_extra_info ext,
318: per_all_assignments_f ass,
319: per_all_people_f peo
320: WHERE adr.person_id(+) = peo.person_id

Line 422: HR_ORGANIZATION_INFORMATION OI1,

418: per_contracts_f con,
419: per_jobs job,
420: hr_locations_all loc,
421: hr_ALL_ORGANIZATION_UNITS OU1,
422: HR_ORGANIZATION_INFORMATION OI1,
423: per_assignment_extra_info ext,
424: per_all_assignments_f ass,
425: per_all_people_f peo
426: WHERE adr.person_id(+) = peo.person_id