APPS.JTF_RS_GROUP_ORGS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 63: l_org_name hr_all_organization_units_tl.NAME%TYPE;

59: l_group_end_date DATE;
60: l_group_name jtf_rs_groups_tl.group_name%TYPE;
61: l_org_start_date DATE;
62: l_org_end_date DATE;
63: l_org_name hr_all_organization_units_tl.NAME%TYPE;
64: l_mapping_exist VARCHAR2(30);
65:
66: CURSOR c_validate_group(ll_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE) IS
67: SELECT start_date_active,

Line 74: CURSOR c_validate_hr_org(ll_org_id IN hr_all_organization_units.organization_id%TYPE) IS

70: FROM jtf_rs_groups_vl
71: WHERE group_id = ll_group_id
72: ;
73:
74: CURSOR c_validate_hr_org(ll_org_id IN hr_all_organization_units.organization_id%TYPE) IS
75: SELECT hr.date_from,
76: NVL(hr.date_to, TRUNC(SYSDATE)+1),
77: hr.NAME
78: FROM hr_all_organization_units_vl hr

Line 78: FROM hr_all_organization_units_vl hr

74: CURSOR c_validate_hr_org(ll_org_id IN hr_all_organization_units.organization_id%TYPE) IS
75: SELECT hr.date_from,
76: NVL(hr.date_to, TRUNC(SYSDATE)+1),
77: hr.NAME
78: FROM hr_all_organization_units_vl hr
79: WHERE hr.organization_id = ll_org_id
80: ;
81:
82: CURSOR c_check_dup_group_org_map(ll_group_id IN JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,