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 691: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id

687: l_time_phase_code Varchar2(80);
688:
689: CURSOR strVer IS
690: SELECT DECODE(nvl(pbv.wp_version_flag,'N'),'Y',pbv.project_structure_version_id,
691: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
692: FROM pa_budget_versions pbv
693: WHERE pbv.budget_version_id = p_budget_version_id;
694:
695:

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

972: ,ppa.org_id
973: ,ppfo.rbs_version_id
974: ,pbv.fin_plan_type_id
975: /* Bug fix: 3839761 --nvl(pbv.project_structure_version_id,
976: --PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
977: */
978: ,pbv.wp_version_flag
979: ,decode(pbv.version_type, 'COST',ppfo.cost_time_phased_code,
980: 'REVENUE',ppfo.revenue_time_phased_code,