DBA Data[Home] [Help]

APPS.FPA_PROJECT_PVT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 46: PER_ORG_STRUCTURE_VERSIONS

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)));

Line 119: l_pjp_org_version_id PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE := null;

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;