DBA Data[Home] [Help]

APPS.PA_FP_PJI_INTG_PKG dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 92: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id

88: PJI_EXCEPTION EXCEPTION;
89:
90: CURSOR strVer IS
91: SELECT DECODE(nvl(pbv.wp_version_flag,'N'),'Y',pbv.project_structure_version_id,
92: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
93: FROM pa_budget_versions pbv
94: WHERE pbv.budget_version_id = p_budget_version_id;
95:
96: CURSOR cur_pjiDetails IS

Line 102: --PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id

98: ,ppa.org_id
99: ,ppfo.rbs_version_id
100: ,pbv.fin_plan_type_id
101: /* Bug fix :3839761 ,nvl(pbv.project_structure_version_id,
102: --PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
103: */
104: ,pbv.wp_version_flag
105: ,decode(pbv.version_type, 'COST',ppfo.cost_time_phased_code,
106: 'REVENUE',ppfo.revenue_time_phased_code,

Line 686: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id

682: l_time_phase_code Varchar2(80);
683:
684: CURSOR strVer IS
685: SELECT DECODE(nvl(pbv.wp_version_flag,'N'),'Y',pbv.project_structure_version_id,
686: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
687: FROM pa_budget_versions pbv
688: WHERE pbv.budget_version_id = p_budget_version_id;
689:
690:

Line 969: --PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id

965: ,ppa.org_id
966: ,ppfo.rbs_version_id
967: ,pbv.fin_plan_type_id
968: /* Bug fix: 3839761 --nvl(pbv.project_structure_version_id,
969: --PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
970: */
971: ,pbv.wp_version_flag
972: ,decode(pbv.version_type, 'COST',ppfo.cost_time_phased_code,
973: 'REVENUE',ppfo.revenue_time_phased_code,