APPS.HR_MEE_VIEWS_GEN dependencies on HR_ORGANIZATION_INFORMATION

Line 354: FROM hr_all_organization_units org, hr_organization_information ori

350:
351: CURSOR c_get_training_center
352: IS
353: SELECT org.name
354: FROM hr_all_organization_units org, hr_organization_information ori
355: WHERE org.organization_id = p_training_center_id
356: AND org.organization_id = ori.organization_id
357: AND ori.org_information_context = 'CLASS'
358: AND ori.org_information1 ='OTA_TC';

Line 1348: -- hr_organization_information

1344: RETURN VARCHAR2
1345: IS
1346:
1347: -- Job Keyflex Id is stored in org_information6 in
1348: -- hr_organization_information
1349: CURSOR lc_get_job_flex_id(p_business_group_id IN NUMBER)
1350: IS
1351: SELECT org_information6
1352: FROM hr_organization_information

Line 1352: FROM hr_organization_information

1348: -- hr_organization_information
1349: CURSOR lc_get_job_flex_id(p_business_group_id IN NUMBER)
1350: IS
1351: SELECT org_information6
1352: FROM hr_organization_information
1353: WHERE organization_id = p_business_group_id
1354: AND org_information_context = 'Business Group Information';
1355:
1356: CURSOR lc_get_job_details(p_job_id IN per_assignments_f.job_id%TYPE)

Line 1498: -- hr_organization_information

1494: RETURN VARCHAR2
1495: IS
1496:
1497: -- Grade Keyflex Id is stored in org_information4 in
1498: -- hr_organization_information
1499: CURSOR lc_get_grade_flex_id(p_business_group_id IN NUMBER)
1500: IS
1501: SELECT org_information4
1502: FROM hr_organization_information

Line 1502: FROM hr_organization_information

1498: -- hr_organization_information
1499: CURSOR lc_get_grade_flex_id(p_business_group_id IN NUMBER)
1500: IS
1501: SELECT org_information4
1502: FROM hr_organization_information
1503: WHERE organization_id = p_business_group_id
1504: AND org_information_context = 'Business Group Information';
1505:
1506: CURSOR lc_get_grade_details(p_grade_id IN per_assignments_f.grade_id%TYPE)

Line 1650: -- hr_organization_information

1646: RETURN VARCHAR2
1647: IS
1648:
1649: -- Position Keyflex Id is stored in org_information8 in
1650: -- hr_organization_information
1651: CURSOR lc_get_position_flex_id(p_business_group_id IN NUMBER)
1652: IS
1653: SELECT org_information8
1654: FROM hr_organization_information

Line 1654: FROM hr_organization_information

1650: -- hr_organization_information
1651: CURSOR lc_get_position_flex_id(p_business_group_id IN NUMBER)
1652: IS
1653: SELECT org_information8
1654: FROM hr_organization_information
1655: WHERE organization_id = p_business_group_id
1656: AND org_information_context = 'Business Group Information';
1657:
1658: CURSOR lc_get_position_details(