APPS.PA_CAP_INT_PVT dependencies on PA_TASKS

Line 721: FROM pa_tasks

717: ln_task_amt NUMBER;
718: /**
719: CURSOR cur_non_cap_tasks IS
720: SELECT task_id
721: FROM pa_tasks
722: WHERE project_id = p_project_id
723: AND task_capital_flag(task_id) = 'N';
724:
725: r_task cur_non_cap_tasks%ROWTYPE;

Line 862: FROM pa_tasks pt

858: lv_cap_flag VARCHAR2(1);
859: BEGIN
860: SELECT pt.task_id,nvl(pt.billable_flag,'N')
861: INTO ln_task_id,lv_cap_flag
862: FROM pa_tasks pt
863: WHERE TRUNC(p_period_end_date) <= TRUNC(NVL(pt.cint_stop_date,p_period_end_date))
864: AND NVL(pt.cint_eligible_flag,'Y') = 'Y'
865: AND TRUNC(p_exp_item_date) BETWEEN
866: TRUNC(NVL(pt.start_date,p_exp_item_date)) AND

Line 1323: ln_target_task_id pa_tasks.task_id%TYPE;

1319: lv_cip_cost_type pa_project_types_all.capital_cost_type_code%TYPE;
1320: lv_burden_method pa_project_types_all.burden_amt_display_method%TYPE;
1321: lv_tot_burden_flag pa_project_types_all.total_burden_flag%TYPE;
1322:
1323: ln_target_task_id pa_tasks.task_id%TYPE;
1324: ln_except_task_id pa_tasks.task_id%TYPE;
1325: lv_target_task_num pa_tasks.task_number%TYPE;
1326:
1327: ln_curr_task_id pa_tasks.task_id%TYPE;

Line 1324: ln_except_task_id pa_tasks.task_id%TYPE;

1320: lv_burden_method pa_project_types_all.burden_amt_display_method%TYPE;
1321: lv_tot_burden_flag pa_project_types_all.total_burden_flag%TYPE;
1322:
1323: ln_target_task_id pa_tasks.task_id%TYPE;
1324: ln_except_task_id pa_tasks.task_id%TYPE;
1325: lv_target_task_num pa_tasks.task_number%TYPE;
1326:
1327: ln_curr_task_id pa_tasks.task_id%TYPE;
1328: lv_curr_task_num pa_tasks.task_number%TYPE;

Line 1325: lv_target_task_num pa_tasks.task_number%TYPE;

1321: lv_tot_burden_flag pa_project_types_all.total_burden_flag%TYPE;
1322:
1323: ln_target_task_id pa_tasks.task_id%TYPE;
1324: ln_except_task_id pa_tasks.task_id%TYPE;
1325: lv_target_task_num pa_tasks.task_number%TYPE;
1326:
1327: ln_curr_task_id pa_tasks.task_id%TYPE;
1328: lv_curr_task_num pa_tasks.task_number%TYPE;
1329: ln_rate_trans_amt NUMBER;

Line 1327: ln_curr_task_id pa_tasks.task_id%TYPE;

1323: ln_target_task_id pa_tasks.task_id%TYPE;
1324: ln_except_task_id pa_tasks.task_id%TYPE;
1325: lv_target_task_num pa_tasks.task_number%TYPE;
1326:
1327: ln_curr_task_id pa_tasks.task_id%TYPE;
1328: lv_curr_task_num pa_tasks.task_number%TYPE;
1329: ln_rate_trans_amt NUMBER;
1330: lv_rate_status pa_alloc_runs.run_status%TYPE;
1331: ln_proj_tot_amt NUMBER;

Line 1328: lv_curr_task_num pa_tasks.task_number%TYPE;

1324: ln_except_task_id pa_tasks.task_id%TYPE;
1325: lv_target_task_num pa_tasks.task_number%TYPE;
1326:
1327: ln_curr_task_id pa_tasks.task_id%TYPE;
1328: lv_curr_task_num pa_tasks.task_number%TYPE;
1329: ln_rate_trans_amt NUMBER;
1330: lv_rate_status pa_alloc_runs.run_status%TYPE;
1331: ln_proj_tot_amt NUMBER;
1332: ln_proj_open_amt NUMBER;