[Home] [Help]
41: )
42: IS
43:
44: l_cost_multiplier pa_labor_cost_multipliers.multiplier%TYPE;
45: l_labor_cost_rate pa_compensation_details_all.HOURLY_COST_RATE%TYPE;
46: l_x_raw_cost NUMBER;
47: l_x_raw_cost_rate NUMBER;
48:
49: l_no_labor_cost_rate EXCEPTION;
51: /*LCE changes*/
52: l_expend_organization_id pa_expenditures_all.incurred_by_organization_id%type;
53: l_exp_org_id pa_expenditures_all.org_id%TYPE; /*2879644*/
54: l_job_id pa_expenditure_items_all.job_id%type;
55: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
56: l_start_date_active date;
57: l_end_date_active date;
58: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
59: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
86:
87: /*****Commented for LCE Changes
88:
89: -----------------------------------------------------------
90: -- Get the labor cost rate from pa_compensation_details_all
91: -----------------------------------------------------------
92:
93: SELECT hourly_cost_rate
94: INTO l_labor_cost_rate
91: -----------------------------------------------------------
92:
93: SELECT hourly_cost_rate
94: INTO l_labor_cost_rate
95: FROM pa_compensation_details_all cd
96: WHERE cd.person_id = p_person_id
97: AND cd.org_id = p_expenditure_org_id --Bug#5903720
98: AND p_item_date BETWEEN cd.start_date_active AND NVL(cd.end_date_active,P_item_date);
99:
2038: l_expend_organization_id pa_expenditures_all.incurred_by_organization_id%type;
2039: l_exp_org_id pa_expenditures_all.org_id%type; /*2879644*/
2040: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
2041: l_acct_currency_code fnd_currencies.currency_code%TYPE;
2042: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
2043: l_start_date_active date;
2044: l_end_date_active date;
2045: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
2046: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;