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 1720: FROM pa_projects_all

1716: l_projfunc_bil_rate_type,
1717: l_projfunc_bil_rate_date,
1718: l_multi_currency_billing_flag,
1719: l_projfunc_bil_exchange_rate
1720: FROM pa_projects_all
1721: WHERE project_id = p_project_id(i);
1722: if p_tp_amt_type_code(i) = 'REVENUE_TRANSFER' THEN /*bug6389559*/
1723: IF ( l_multi_currency_billing_flag = 'Y' ) THEN
1724:

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

4275: x_burdening_allowed OUT NOCOPY VARCHAR2, /*File.sql.39*/
4276: x_burden_amt_display_method OUT NOCOPY VARCHAR2 /*File.sql.39*/
4277: )
4278: IS
4279: /* Bug 1729820 _ Changed to pa_projects_all and pa_project_types_all */
4280:
4281: Cursor c_burdening_details
4282: IS
4283: select type.burden_cost_flag,type.burden_amt_display_method

Line 4284: from pa_projects_all proj ,pa_project_types_all type

4280:
4281: Cursor c_burdening_details
4282: IS
4283: select type.burden_cost_flag,type.burden_amt_display_method
4284: from pa_projects_all proj ,pa_project_types_all type
4285: where proj.project_id = p_project_id
4286: and proj.project_type = type.project_type
4287: and proj.org_id = type.org_id; /** Added this condition while making changes for Org Forecasting **/
4288: BEGIN

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

4735: AND PERIODS.PERIOD_NAME = C_PVDR_PA_PERIOD_NAME
4736: AND PERIODS.ORG_ID = C_EXPENDITURE_ORG_ID
4737: AND FCST.ORG_ID = C_PROJECT_ORG_ID;
4738:
4739: Cursor Proj_Details(c_project_id pa_projects_all.project_id%type) IS
4740: SELECT Project_Type,
4741: DISTRIBUTION_RULE,
4742: BILL_JOB_GROUP_ID,
4743: COST_JOB_GROUP_ID,

Line 4768: FROM Pa_Projects_All P

4764: LABOR_BILL_RATE_ORG_ID,
4765: LABOR_STD_BILL_RATE_SCHDL,
4766: LABOR_SCHEDULE_FIXED_DATE,
4767: LABOR_SCH_TYPE
4768: FROM Pa_Projects_All P
4769: WHERE P.Project_Id = c_project_id;
4770:
4771: Cursor Proj_Assignment(c_assignment_id pa_project_assignments.assignment_id%type) IS
4772: SELECT Fcst_Job_Id,

Line 4821: l_prj_type Pa_Projects_All.Project_Type%TYPE;

4817: lx_cc_error_stage VARCHAR2(500);
4818: lx_cc_error_code NUMBER;
4819:
4820: /* Project Info */
4821: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

Line 4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;

4818: lx_cc_error_code NUMBER;
4819:
4820: /* Project Info */
4821: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

Line 4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;

4819:
4820: /* Project Info */
4821: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;

Line 4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;

4820: /* Project Info */
4821: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

Line 4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;

4821: l_prj_type Pa_Projects_All.Project_Type%TYPE;
4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

Line 4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;

4822: l_distribution_rule Pa_Projects_All.Distribution_Rule%TYPE;
4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

Line 4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;

4823: l_bill_job_group_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;
4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

Line 4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;

4824: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

Line 4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;

4825: l_job_bill_rate_sch_id Pa_Projects_All.JOB_BILL_RATE_SCHEDULE_ID%TYPE;
4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

Line 4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;

4826: l_emp_bill_rate_sch_id Pa_Projects_All.EMP_BILL_RATE_SCHEDULE_ID%TYPE;
4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;

Line 4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;

4827: l_prj_curr_code Pa_Projects_All.PROJECT_CURRENCY_CODE%TYPE;
4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

Line 4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;

4828: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;
4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

Line 4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;

4829: l_prj_rate_type Pa_Projects_All.PROJECT_RATE_TYPE%TYPE;
4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;

Line 4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;

4830: l_prj_bil_rate_date_code Pa_Projects_All.PROJECT_BIL_RATE_DATE_CODE%TYPE;
4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;

Line 4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;

4831: l_prj_bil_rate_type Pa_Projects_All.PROJECT_BIL_RATE_TYPE%TYPE;
4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;

Line 4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;

4832: l_prj_bil_rate_date Pa_Projects_All.PROJECT_BIL_RATE_DATE%TYPE;
4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;

Line 4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;

4833: l_prj_bil_ex_rate Pa_Projects_All.PROJECT_BIL_EXCHANGE_RATE%TYPE;
4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

Line 4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;

4834: l_prjfunc_curr_code Pa_Projects_All.PROJFUNC_CURRENCY_CODE%TYPE;
4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

Line 4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;

4835: l_prjfunc_cost_rate_type Pa_Projects_All.PROJFUNC_COST_RATE_TYPE%TYPE;
4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

Line 4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;

4836: l_prjfunc_cost_rate_date Pa_Projects_All.PROJFUNC_COST_RATE_DATE%TYPE;
4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

Line 4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;

4837: l_prjfunc_bil_rate_date_code Pa_Projects_All.PROJFUNC_BIL_RATE_DATE_CODE%TYPE;
4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

Line 4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;

4838: l_prjfunc_bil_rate_type Pa_Projects_All.PROJFUNC_BIL_RATE_TYPE%TYPE;
4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

Line 4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;

4839: l_prjfunc_bil_rate_date Pa_Projects_All.PROJFUNC_BIL_RATE_DATE%TYPE;
4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

Line 4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;

4840: l_prjfunc_bil_ex_rate Pa_Projects_All.PROJFUNC_BIL_EXCHANGE_RATE%TYPE;
4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4848: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

Line 4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;

4841: l_labor_tp_schedule_id Pa_Projects_All.LABOR_TP_SCHEDULE_ID%TYPE;
4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4848: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4849:

Line 4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;

4842: l_labor_tp_fixed_date Pa_Projects_All.LABOR_TP_FIXED_DATE%TYPE;
4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4848: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4849:
4850: l_fcst_opt_jobcostrate_sch_id NUMBER;

Line 4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;

4843: l_labor_sch_discount Pa_Projects_All.LABOR_SCHEDULE_DISCOUNT%TYPE;
4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4848: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4849:
4850: l_fcst_opt_jobcostrate_sch_id NUMBER;
4851:

Line 4848: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;

4844: l_asg_precedes_task Pa_Projects_All.ASSIGN_PRECEDES_TASK%TYPE;
4845: l_labor_bill_rate_orgid Pa_Projects_All.LABOR_BILL_RATE_ORG_ID%TYPE;
4846: l_labor_std_bill_rate_sch Pa_Projects_All.LABOR_STD_BILL_RATE_SCHDL%TYPE;
4847: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
4848: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
4849:
4850: l_fcst_opt_jobcostrate_sch_id NUMBER;
4851:
4852: /* Project Assignment Info */