DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_FP_ROLLUP_TMP

Line 2887: DELETE FROM PA_FP_ROLLUP_TMP;

2883: print_msg(l_debug_flag,l_proc_name,l_stage);
2884:
2885: /* Initialize tmp tables */
2886: DELETE FROM PA_FP_RES_ASSIGNMENTS_TMP;
2887: DELETE FROM PA_FP_ROLLUP_TMP;
2888:
2889: /* Validate Input Params */
2890: l_resource_assignment_id_tab := p_resource_assignment_id_tab;
2891: l_resource_list_member_Id_tab := p_resource_list_member_Id_tab;

Line 3550: INSERT INTO pa_fp_rollup_tmp tmp

3546: /*** Not required as re arrangig the plsql indexes
3547: IF l_rowid_tab.COUNT > 0 Then
3548: l_stage := 'Inserting rate api values into rollup tmp table';
3549: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
3550: INSERT INTO pa_fp_rollup_tmp tmp
3551: (resource_assignment_id
3552: ,system_reference1
3553: ,txn_currency_code
3554: ,cost_rate