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

Line 604: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

600: , X_date IN DATE ) RETURN NUMBER
601: IS
602: X_cost_rate NUMBER(22,5);
603: l_job_id pa_expenditure_items_all.job_id%type;
604: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
605: l_start_date_active date;
606: l_end_date_active date;
607: l_organization_id number;
608: l_org_id number; /*2879644*/

Line 611: l_override_type pa_compensation_details.override_type%type;

607: l_organization_id number;
608: l_org_id number; /*2879644*/
609: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
610: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
611: l_override_type pa_compensation_details.override_type%type;
612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
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;

Line 612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;

608: l_org_id number; /*2879644*/
609: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
610: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
611: l_override_type pa_compensation_details.override_type%type;
612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
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;

Line 613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

609: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
610: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
611: l_override_type pa_compensation_details.override_type%type;
612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
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;

Line 614: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;

610: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
611: l_override_type pa_compensation_details.override_type%type;
612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
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;

Line 615: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

611: l_override_type pa_compensation_details.override_type%type;
612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
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);

Line 616: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;

612: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
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;

Line 656: pa_compensation_details cd

652: cd.hourly_cost_rate
653: INTO
654: X_cost_rate
655: FROM
656: pa_compensation_details cd
657: WHERE
658: cd.person_id = X_person_id
659: AND X_date BETWEEN cd.start_date_active
660: AND nvl( cd.end_date_active, X_date );

Line 2079: from pa_compensation_details detail

2075: ,detail.acct_rate_date_code
2076: ,detail.acct_exchange_rate
2077: ,detail.base_hours
2078: ,detail.rbc_element_type_id
2079: from pa_compensation_details detail
2080: ,pa_expenditure_items ei
2081: ,pa_expenditures exp
2082: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
2083: and trunc(nvl(detail.end_date_active,p_exp_item_date))

Line 2219: from pa_compensation_details detail

2215: ,detail.acct_rate_date_code
2216: ,detail.acct_exchange_rate
2217: ,detail.base_hours
2218: ,detail.rbc_element_type_id
2219: from pa_compensation_details detail
2220: ,pa_expenditure_items ei
2221: ,pa_expenditures exp
2222: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
2223: and trunc(nvl(detail.end_date_active,p_exp_item_date))

Line 2265: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%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;
2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2265: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2266: lx_err_stage number;
2267: lx_err_code varchar2(150);
2268:
2269:

Line 2359: from pa_compensation_details detail

2355: ,detail.acct_rate_date_code
2356: ,detail.acct_exchange_rate
2357: ,detail.base_hours
2358: ,detail.rbc_element_type_id
2359: from pa_compensation_details detail
2360: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
2361: and trunc(nvl(detail.end_date_active,p_exp_item_date))
2362: and detail.person_id = p_incurred_by_person_id;
2363:

Line 2396: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%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;
2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2396: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2397: lx_err_stage number;
2398: lx_err_code varchar2(150);
2399:
2400: