eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_PROJECTS_ALL

Line 1780: FROM pa_projects_all

1776: l_projfunc_bil_rate_type,
1777: l_projfunc_bil_rate_date,
1778: l_multi_currency_billing_flag,
1779: l_projfunc_bil_exchange_rate
1780: FROM pa_projects_all
1781: WHERE project_id = p_project_id(i);
1782: if p_tp_amt_type_code(i) = 'REVENUE_TRANSFER' THEN /*bug6389559*/
1783: IF ( l_multi_currency_billing_flag = 'Y' ) THEN
1784:

Line 4375: /* Bug 1729820 _ Changed to pa_projects_all and pa_project_types_all */

4371: x_burdening_allowed OUT NOCOPY VARCHAR2, /*File.sql.39*/
4372: x_burden_amt_display_method OUT NOCOPY VARCHAR2 /*File.sql.39*/
4373: )
4374: IS
4375: /* Bug 1729820 _ Changed to pa_projects_all and pa_project_types_all */
4376:
4377: Cursor c_burdening_details
4378: IS
4379: select type.burden_cost_flag,type.burden_amt_display_method

Line 4380: from pa_projects_all proj ,pa_project_types_all type

4376:
4377: Cursor c_burdening_details
4378: IS
4379: select type.burden_cost_flag,type.burden_amt_display_method
4380: from pa_projects_all proj ,pa_project_types_all type
4381: where proj.project_id = p_project_id
4382: and proj.project_type = type.project_type
4383: and proj.org_id = type.org_id; /** Added this condition while making changes for Org Forecasting **/
4384: BEGIN

Line 4835: Cursor Proj_Details(c_project_id pa_projects_all.project_id%type) IS

4831: AND PERIODS.PERIOD_NAME = C_PVDR_PA_PERIOD_NAME
4832: AND PERIODS.ORG_ID = C_EXPENDITURE_ORG_ID
4833: AND FCST.ORG_ID = C_PROJECT_ORG_ID;
4834:
4835: Cursor Proj_Details(c_project_id pa_projects_all.project_id%type) IS
4836: SELECT Project_Type,
4837: DISTRIBUTION_RULE,
4838: BILL_JOB_GROUP_ID,
4839: COST_JOB_GROUP_ID,

Line 4864: FROM Pa_Projects_All P

4860: LABOR_BILL_RATE_ORG_ID,
4861: LABOR_STD_BILL_RATE_SCHDL,
4862: LABOR_SCHEDULE_FIXED_DATE,
4863: LABOR_SCH_TYPE
4864: FROM Pa_Projects_All P
4865: WHERE P.Project_Id = c_project_id;
4866:
4867: Cursor Proj_Assignment(c_assignment_id pa_project_assignments.assignment_id%type) IS
4868: SELECT Fcst_Job_Id,

Line 4917: l_prj_type Pa_Projects_All.Project_Type%TYPE;

4913: lx_cc_error_stage VARCHAR2(500);
4914: lx_cc_error_code NUMBER;
4915:
4916: /* Project Info */
4917: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

Line 4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;

4914: lx_cc_error_code NUMBER;
4915:
4916: /* Project Info */
4917: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

Line 4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;

4915:
4916: /* Project Info */
4917: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;

Line 4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;

4916: /* Project Info */
4917: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

Line 4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

4917: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

Line 4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

4918: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

Line 4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;

4919: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

Line 4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

4920: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

Line 4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

4921: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

4922: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;

Line 4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

4923: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

Line 4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

4924: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

Line 4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

4925: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;

Line 4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;

4926: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;

Line 4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

4927: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;

Line 4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

4928: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;

Line 4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;

4929: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

Line 4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;

4930: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

Line 4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;

4931: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

Line 4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;

4932: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

Line 4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

4933: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

Line 4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

4934: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

Line 4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

4935: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

Line 4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

4936: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4944: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

Line 4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

4937: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4944: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4945:

Line 4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

4938: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4944: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4945:
4946: l_fcst_opt_jobcostrate_sch_id NUMBER;

Line 4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

4939: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4944: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4945:
4946: l_fcst_opt_jobcostrate_sch_id NUMBER;
4947:

Line 4944: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

4940: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4941: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4942: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4943: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4944: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4945:
4946: l_fcst_opt_jobcostrate_sch_id NUMBER;
4947:
4948: /* Project Assignment Info */