[Home] [Help]
85: INTO
86: X_task_num
87: ,X_task_name
88: FROM
89: pa_tasks
90: WHERE
91: task_id = X_task_id;
92:
93: G_PREV_TASK_NUM := x_task_num;
251: task_id
252: INTO
253: X_task_id
254: FROM
255: pa_tasks
256: WHERE
257: project_id = X_proj_id
258: AND task_number = X_task_num;
259:
614: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
615: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
616: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
617: l_ot_project_id pa_projects_all.project_id%type;
618: l_ot_task_id pa_tasks.task_id%type;
619: l_err_code varchar2(200);
620: l_err_stage number;
621: l_return_value varchar2(100);
622:
2255: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2256: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2257: lx_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
2258: lx_ot_project_id pa_projects_all.project_id%TYPE;
2259: lx_ot_task_id pa_tasks.task_id%TYPE;
2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2261: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2263: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2386: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2387: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2388: lx_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
2389: lx_ot_project_id pa_projects_all.project_id%TYPE;
2390: lx_ot_task_id pa_tasks.task_id%TYPE;
2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2392: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2394: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;