42: CURSOR HIER_VERSION_CSR IS
43: SELECT
44: ORG_STRUCTURE_VERSION_ID
45: FROM
46: PER_ORG_STRUCTURE_VERSIONS
47: WHERE
48: ORGANIZATION_STRUCTURE_ID = G_PJP_ORGS_HIER
49: AND (TRUNC(SYSDATE) BETWEEN TRUNC(DATE_FROM) AND TRUNC(NVL(DATE_TO,
50: SYSDATE)));
115: l_class_code PA_CLASS_CODES.CLASS_CODE%TYPE := null;
116: l_class_code_id PA_CLASS_CODES.CLASS_CODE_ID%TYPE := null;
117: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
118: l_project_org_id HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE := null;
119: l_pjp_org_version_id PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE := null;
120: l_flag VARCHAR2(1) := null;
121:
122: BEGIN
123: x_valid_project := FND_API.G_FALSE;