APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_PROJ_PERIODS_DENORM

Line 3985: -- used to query pa_proj_periods_denorm table

3981: x_return_status := FND_API.G_RET_STS_SUCCESS;
3982: x_msg_count := 0;
3983: SAVEPOINT VIEW_PLANS_POP_TABLES_SEP;
3984:
3985: -- used to query pa_proj_periods_denorm table
3986: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,
3987: 'PROJFUNC', 'PROJ_FUNCTIONAL',
3988: 'PROJ', 'PROJECT',
3989: 'TRANSACTION')

Line 7063: -- used to query pa_proj_periods_denorm table

7059: x_return_status := FND_API.G_RET_STS_SUCCESS;
7060: x_msg_count := 0;
7061: SAVEPOINT VIEW_PLANS_POP_TABLES_SAME;
7062:
7063: -- used to query pa_proj_periods_denorm table
7064: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,
7065: 'PROJFUNC', 'PROJ_FUNCTIONAL',
7066: 'PROJ', 'PROJECT',
7067: 'TRANSACTION')

Line 8536: -- used to query pa_proj_periods_denorm table

8532: --hr_utility.trace('entered pa_fp_vp_pop_tables_single:100');
8533: x_return_status := FND_API.G_RET_STS_SUCCESS;
8534: x_msg_count := 0;
8535: SAVEPOINT VIEW_PLANS_POP_TABLES_SINGLE;
8536: -- used to query pa_proj_periods_denorm table
8537: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,
8538: 'PROJFUNC', 'PROJ_FUNCTIONAL',
8539: 'PROJ', 'PROJECT',
8540: 'TRANSACTION')

Line 10598: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,

10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
10596: p_task_id IN pa_resource_assignments.task_id%TYPE,
10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
10598: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
10599: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
10600: IS
10601:
10602: l_return_value VARCHAR2(1);