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_COST dependencies on PA_COMPENSATION_DETAILS

Line 45: l_labor_cost_rate pa_compensation_details_all.HOURLY_COST_RATE%TYPE;

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;

Line 55: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

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;

Line 60: l_override_type pa_compensation_details.override_type%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;
60: l_override_type pa_compensation_details.override_type%type;
61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

Line 61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;

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;
60: l_override_type pa_compensation_details.override_type%type;
61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;

Line 62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

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;
60: l_override_type pa_compensation_details.override_type%type;
61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;

Line 63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;

59: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
60: l_override_type pa_compensation_details.override_type%type;
61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;
67: l_ot_task_id pa_tasks.task_id%type;

Line 64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

60: l_override_type pa_compensation_details.override_type%type;
61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;
67: l_ot_task_id pa_tasks.task_id%type;
68: l_err_code varchar2(200);

Line 65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;

61: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;
67: l_ot_task_id pa_tasks.task_id%type;
68: l_err_code varchar2(200);
69: l_err_stage number;

Line 90: -- Get the labor cost rate from pa_compensation_details_all

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

Line 95: FROM pa_compensation_details_all cd

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:

Line 2073: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;

2069:
2070: /*LCE changes*/
2071: l_expend_organization_id pa_expenditures_all.incurred_by_organization_id%type;
2072: l_exp_org_id pa_expenditures_all.org_id%type; /*2879644*/
2073: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
2074: l_acct_currency_code fnd_currencies.currency_code%TYPE;
2075: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
2076: l_start_date_active date;
2077: l_end_date_active date;

Line 2075: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

2071: l_expend_organization_id pa_expenditures_all.incurred_by_organization_id%type;
2072: l_exp_org_id pa_expenditures_all.org_id%type; /*2879644*/
2073: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
2074: l_acct_currency_code fnd_currencies.currency_code%TYPE;
2075: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
2076: l_start_date_active date;
2077: l_end_date_active date;
2078: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
2079: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;

Line 2080: l_override_type pa_compensation_details.override_type%type;

2076: l_start_date_active date;
2077: l_end_date_active date;
2078: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
2079: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
2080: l_override_type pa_compensation_details.override_type%type;
2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2084: l_ot_project_id pa_projects_all.project_id%type;

Line 2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

2077: l_end_date_active date;
2078: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
2079: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
2080: l_override_type pa_compensation_details.override_type%type;
2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2084: l_ot_project_id pa_projects_all.project_id%type;
2085: l_ot_task_id pa_tasks.task_id%type;

Line 2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;

2078: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
2079: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
2080: l_override_type pa_compensation_details.override_type%type;
2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2084: l_ot_project_id pa_projects_all.project_id%type;
2085: l_ot_task_id pa_tasks.task_id%type;
2086: l_err_code varchar2(200);

Line 2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

2079: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
2080: l_override_type pa_compensation_details.override_type%type;
2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2084: l_ot_project_id pa_projects_all.project_id%type;
2085: l_ot_task_id pa_tasks.task_id%type;
2086: l_err_code varchar2(200);
2087: l_err_stage number;