APPS.PJI_PMV_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 931: x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,

927: --> x_insert_top_org : Flag indicating whether the user has permissions to the see the top org in the
928: -- hierarchy
929: PROCEDURE get_top_org_details
930: (x_top_org_id OUT nocopy per_security_profiles.organization_id%TYPE,
931: x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,
932: x_user_assmt_flag OUT nocopy VARCHAR2,
933: x_insert_top_org_flag OUT nocopy VARCHAR2 )
934: IS
935: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

Line 980: FROM hr_all_organization_units_tl

976: IF x_insert_top_org_flag = 'Y' THEN
977:
978: SELECT name
979: INTO x_top_org_name
980: FROM hr_all_organization_units_tl
981: WHERE organization_id = x_top_org_id
982: AND language = USERENV('LANG');
983:
984: END IF;

Line 1004: l_top_org_name hr_all_organization_units_tl.name%TYPE;

1000: l_Count NUMBER;
1001: --Bug 4599990.
1002: l_top_organization_id per_security_profiles.organization_id%TYPE;
1003: l_user_id NUMBER;
1004: l_top_org_name hr_all_organization_units_tl.name%TYPE;
1005: l_user_assmt_flag VARCHAR2(1);
1006: l_insert_top_org_flag VARCHAR2(1);
1007:
1008: BEGIN

Line 1031: , hr_all_organization_units_tl org

1027: BULK COLLECT INTO l_Organization_List
1028: FROM
1029: per_org_structure_elements orgd
1030: , pji_system_settings pset
1031: , hr_all_organization_units_tl org
1032: WHERE 1=1
1033: AND orgd.org_structure_version_id = pset.org_structure_version_id
1034: AND orgd.organization_id_child = org.organization_id
1035: AND org.language = USERENV('LANG');

Line 1052: , hr_all_organization_units_tl org

1048: FROM
1049: per_org_structure_elements orgd
1050: , pji_system_settings pset
1051: , per_organization_list sec
1052: , hr_all_organization_units_tl org
1053: WHERE 1=1
1054: AND orgd.org_structure_version_id = pset.org_structure_version_id
1055: AND orgd.organization_id_child = org.organization_id
1056: AND org.language = USERENV('LANG')

Line 1074: , hr_all_organization_units_tl org

1070: BULK COLLECT INTO l_Organization_List
1071: FROM
1072: per_org_structure_elements orgd
1073: , pji_system_settings pset
1074: , hr_all_organization_units_tl org
1075: WHERE 1=1
1076: AND orgd.org_structure_version_id = pset.org_structure_version_id
1077: AND orgd.organization_id_child = org.organization_id
1078: AND org.language = USERENV('LANG')

Line 1107: , hr_all_organization_units_tl org

1103: per_org_structure_elements c
1104: where c.organization_id_child = p.organization_id_parent
1105: and c.org_structure_version_id = p.org_structure_version_id)) orgd
1106: , per_organization_list sec
1107: , hr_all_organization_units_tl org
1108: , per_security_profiles prof
1109: WHERE 1=1
1110: AND orgd.organization_id_child = org.organization_id
1111: AND org.language = USERENV('LANG')

Line 1154: l_top_org_name hr_all_organization_units_tl.name%TYPE;

1150: FUNCTION PJI_ORGANIZATION_EXISTS(p_org_id IN NUMBER) RETURN NUMBER
1151: IS
1152: l_top_organization_id per_security_profiles.organization_id%TYPE;
1153: l_org_id per_security_profiles.organization_id%TYPE;
1154: l_top_org_name hr_all_organization_units_tl.name%TYPE;
1155: l_user_assmt_flag VARCHAR2(1);
1156: l_insert_top_org_flag VARCHAR2(1);
1157:
1158: BEGIN