APPS.GHR_GHRCPDFO_XMLP_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 24: L_ORG_STR_VERSION_ID PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE;

20: P_AGENCY_CODE VARCHAR2(30) := P_AGENCY_CODE;
21: P_AGENCY_SUBELEMENT VARCHAR2(30) := P_AGENCY_SUBELEMENT;*/
22: L_COUNT NUMBER;
23: L_DUMMY NUMBER;
24: L_ORG_STR_VERSION_ID PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE;
25: L_BUS_GROUP_ID PER_ORGANIZATION_STRUCTURES.BUSINESS_GROUP_ID%TYPE;
26: CURSOR C_PARENT IS
27: SELECT
28: DISTINCT

Line 39: PER_ORG_STRUCTURE_VERSIONS VER

35: SELECT
36: ORGANIZATION_ID_CHILD
37: FROM
38: PER_ORG_STRUCTURE_ELEMENTS ELE,
39: PER_ORG_STRUCTURE_VERSIONS VER
40: WHERE VER.ORGANIZATION_STRUCTURE_ID = P_ORGANIZATION_HIERARCHY
41: AND VER.ORG_STRUCTURE_VERSION_ID = ELE.ORG_STRUCTURE_VERSION_ID
42: AND VER.ORG_STRUCTURE_VERSION_ID = P_HIERARCHY_VERSION )
43: AND ELE.ORG_STRUCTURE_VERSION_ID = P_HIERARCHY_VERSION;

Line 136: PER_ORG_STRUCTURE_VERSIONS B,

132: ,' ') TITLE,
133: PPDK.SEGMENT4 AGENCY_SUBELEMENT
134: FROM
135: PER_ORG_STRUCTURE_ELEMENTS A,
136: PER_ORG_STRUCTURE_VERSIONS B,
137: HR_ORGANIZATION_INFORMATION OEI,
138: HR_ORGANIZATION_UNITS HRU,
139: PER_POSITION_EXTRA_INFO PPEI,
140: PER_POSITIONS PPOS,

Line 210: PER_ORG_STRUCTURE_VERSIONS VER

206: STRUC.BUSINESS_GROUP_ID BUS_ID
207: INTO L_ORG_STR_VERSION_ID,L_BUS_GROUP_ID
208: FROM
209: PER_ORGANIZATION_STRUCTURES STRUC,
210: PER_ORG_STRUCTURE_VERSIONS VER
211: WHERE STRUC.ORGANIZATION_STRUCTURE_ID = P_ORGANIZATION_HIERARCHY
212: AND STRUC.ORGANIZATION_STRUCTURE_ID = VER.ORGANIZATION_STRUCTURE_ID
213: AND VER.ORG_STRUCTURE_VERSION_ID = P_HIERARCHY_VERSION
214: AND P_REPORT_DATE >= VER.DATE_FROM