APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_PROJ_PERIODS_DENORM

Line 3835: -- used to query pa_proj_periods_denorm table

3831: x_return_status := FND_API.G_RET_STS_SUCCESS;
3832: x_msg_count := 0;
3833: SAVEPOINT VIEW_PLANS_POP_TABLES_SEP;
3834:
3835: -- used to query pa_proj_periods_denorm table
3836: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,
3837: 'PROJFUNC', 'PROJ_FUNCTIONAL',
3838: 'PROJ', 'PROJECT',
3839: 'TRANSACTION')

Line 6414: -- used to query pa_proj_periods_denorm table

6410: x_return_status := FND_API.G_RET_STS_SUCCESS;
6411: x_msg_count := 0;
6412: SAVEPOINT VIEW_PLANS_POP_TABLES_SAME;
6413:
6414: -- used to query pa_proj_periods_denorm table
6415: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,
6416: 'PROJFUNC', 'PROJ_FUNCTIONAL',
6417: 'PROJ', 'PROJECT',
6418: 'TRANSACTION')

Line 7528: -- used to query pa_proj_periods_denorm table

7524: --hr_utility.trace('entered pa_fp_vp_pop_tables_single:100');
7525: x_return_status := FND_API.G_RET_STS_SUCCESS;
7526: x_msg_count := 0;
7527: SAVEPOINT VIEW_PLANS_POP_TABLES_SINGLE;
7528: -- used to query pa_proj_periods_denorm table
7529: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,
7530: 'PROJFUNC', 'PROJ_FUNCTIONAL',
7531: 'PROJ', 'PROJECT',
7532: 'TRANSACTION')

Line 8989: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,

8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
8987: p_task_id IN pa_resource_assignments.task_id%TYPE,
8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
8989: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
8990: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
8991: IS
8992:
8993: l_return_value VARCHAR2(1);