APPS.PER_IN_ASG_LEG_HOOK dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 54: FROM hr_all_organization_units_tl

50: )
51: IS
52: CURSOR c_org_name (p_org_id IN NUMBER) IS
53: SELECT name
54: FROM hr_all_organization_units_tl
55: WHERE organization_id = p_org_id
56: AND language = userenv('LANG');
57:
58: l_pf_org hr_all_organization_units_tl.name%TYPE;

Line 58: l_pf_org hr_all_organization_units_tl.name%TYPE;

54: FROM hr_all_organization_units_tl
55: WHERE organization_id = p_org_id
56: AND language = userenv('LANG');
57:
58: l_pf_org hr_all_organization_units_tl.name%TYPE;
59: l_gre_org hr_all_organization_units_tl.name%TYPE;
60: l_esi_org hr_all_organization_units_tl.name%TYPE;
61: l_message VARCHAR2(255);
62: l_procedure VARCHAR2(100);

Line 59: l_gre_org hr_all_organization_units_tl.name%TYPE;

55: WHERE organization_id = p_org_id
56: AND language = userenv('LANG');
57:
58: l_pf_org hr_all_organization_units_tl.name%TYPE;
59: l_gre_org hr_all_organization_units_tl.name%TYPE;
60: l_esi_org hr_all_organization_units_tl.name%TYPE;
61: l_message VARCHAR2(255);
62: l_procedure VARCHAR2(100);
63:

Line 60: l_esi_org hr_all_organization_units_tl.name%TYPE;

56: AND language = userenv('LANG');
57:
58: l_pf_org hr_all_organization_units_tl.name%TYPE;
59: l_gre_org hr_all_organization_units_tl.name%TYPE;
60: l_esi_org hr_all_organization_units_tl.name%TYPE;
61: l_message VARCHAR2(255);
62: l_procedure VARCHAR2(100);
63:
64: BEGIN