APPS.PQH_FR_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

Line 26: FROM HR_ORGANIZATION_INFORMATION HOI,

22: -- Mofied for Bug 6031763
23: --CURSOR CSR_GET_LEGISLATION IS
24: CURSOR CSR_GET_LEGISLATION(CSR_L_INFORMATION67 VARCHAR2) IS
25: SELECT ORG_INFORMATION9
26: FROM HR_ORGANIZATION_INFORMATION HOI,
27: PER_ALL_ASSIGNMENTS_F PAF
28: WHERE PAF.ASSIGNMENT_ID = P_INFORMATION2
29: AND FND_DATE.CANONICAL_TO_DATE(CSR_L_INFORMATION67) BETWEEN PAF.EFFECTIVE_START_DATE
30: AND PAF.EFFECTIVE_END_DATE

Line 44: l_legislation hr_organization_information.org_information9%type;

40:
41: -- Local Variables
42: l_duplicate number;
43:
44: l_legislation hr_organization_information.org_information9%type;
45:
46: l_context pqh_copy_entity_txns.context%type;
47:
48: -- Added for Bug 6031763

Line 1148: from per_shared_types_vl sh , hr_organization_information O

1144: IS
1145: --
1146: Cursor csr_get_bg_typ_of_ps IS
1147: Select System_type_cd
1148: from per_shared_types_vl sh , hr_organization_information O
1149: where O.org_information_context = 'FR_PQH_GROUPING_UNIT_INFO'
1150: and O.organization_id = hr_general.get_business_group_id
1151: and sh.shared_type_id = o.org_information1;
1152: --

Line 1605: FROM hr_organization_information_v

1601: RETURN VARCHAR2 IS
1602: --
1603: CURSOR csr_working_hours(p_estab_id NUMBER) IS
1604: SELECT FND_NUMBER.canonical_to_number(org_information4) hours, 'M' frequency
1605: FROM hr_organization_information_v
1606: WHERE org_information_context = 'FR_ESTAB_INFO'
1607: AND organization_id = p_estab_id;
1608: --
1609: --Variable Declarations.

Line 2001: FROM hr_organization_information

1997: SELECT information1
1998: FROM per_shared_types
1999: WHERE lookup_type = 'FR_PQH_ORG_CATEGORY'
2000: AND shared_type_id =(SELECT org_information1
2001: FROM hr_organization_information
2002: WHERE org_information_context = 'FR_PQH_GROUPING_UNIT_INFO'
2003: AND organization_id =(SELECT business_group_id
2004: FROM per_all_people_f
2005: WHERE person_id = p_person_id

Line 2111: ,hr_organization_information hri

2107: IS
2108: CURSOR c_owner_cur IS
2109: SELECT hru.name
2110: FROM hr_all_organization_units hru
2111: ,hr_organization_information hri
2112: WHERE hru.organization_id = p_org_id
2113: AND hru.organization_id = hri.organization_id
2114: AND hri.org_information_context = 'CLASS'
2115: AND hri.org_information1 IN ('FR_ETABLISSEMENT','FR_SOCIETE','HR_BG')