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 1391: -- hr_organization_information

1387: RETURN VARCHAR2
1388: IS
1389:
1390: -- Job Keyflex Id is stored in org_information6 in
1391: -- hr_organization_information
1392: CURSOR lc_get_job_flex_id(p_business_group_id IN NUMBER)
1393: IS
1394: SELECT org_information6
1395: FROM hr_organization_information

Line 1395: FROM hr_organization_information

1391: -- hr_organization_information
1392: CURSOR lc_get_job_flex_id(p_business_group_id IN NUMBER)
1393: IS
1394: SELECT org_information6
1395: FROM hr_organization_information
1396: WHERE organization_id = p_business_group_id
1397: AND org_information_context = 'Business Group Information';
1398:
1399: CURSOR lc_get_job_details(p_job_id IN per_assignments_f.job_id%TYPE)

Line 1541: -- hr_organization_information

1537: RETURN VARCHAR2
1538: IS
1539:
1540: -- Grade Keyflex Id is stored in org_information4 in
1541: -- hr_organization_information
1542: CURSOR lc_get_grade_flex_id(p_business_group_id IN NUMBER)
1543: IS
1544: SELECT org_information4
1545: FROM hr_organization_information

Line 1545: FROM hr_organization_information

1541: -- hr_organization_information
1542: CURSOR lc_get_grade_flex_id(p_business_group_id IN NUMBER)
1543: IS
1544: SELECT org_information4
1545: FROM hr_organization_information
1546: WHERE organization_id = p_business_group_id
1547: AND org_information_context = 'Business Group Information';
1548:
1549: CURSOR lc_get_grade_details(p_grade_id IN per_assignments_f.grade_id%TYPE)

Line 1693: -- hr_organization_information

1689: RETURN VARCHAR2
1690: IS
1691:
1692: -- Position Keyflex Id is stored in org_information8 in
1693: -- hr_organization_information
1694: CURSOR lc_get_position_flex_id(p_business_group_id IN NUMBER)
1695: IS
1696: SELECT org_information8
1697: FROM hr_organization_information

Line 1697: FROM hr_organization_information

1693: -- hr_organization_information
1694: CURSOR lc_get_position_flex_id(p_business_group_id IN NUMBER)
1695: IS
1696: SELECT org_information8
1697: FROM hr_organization_information
1698: WHERE organization_id = p_business_group_id
1699: AND org_information_context = 'Business Group Information';
1700:
1701: CURSOR lc_get_position_details(