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.

[Home] [Help]

APPS.PA_UTILS dependencies on PA_COMPENSATION_DETAILS

Line 562: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

558: , X_date IN DATE ) RETURN NUMBER
559: IS
560: X_cost_rate NUMBER(22,5);
561: l_job_id pa_expenditure_items_all.job_id%type;
562: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
563: l_start_date_active date;
564: l_end_date_active date;
565: l_organization_id number;
566: l_org_id number; /*2879644*/

Line 569: l_override_type pa_compensation_details.override_type%type;

565: l_organization_id number;
566: l_org_id number; /*2879644*/
567: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
568: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
569: l_override_type pa_compensation_details.override_type%type;
570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

Line 570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;

566: l_org_id number; /*2879644*/
567: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
568: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
569: l_override_type pa_compensation_details.override_type%type;
570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
574: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;

Line 571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

567: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
568: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
569: l_override_type pa_compensation_details.override_type%type;
570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
574: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
575: l_ot_project_id pa_projects_all.project_id%type;

Line 572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;

568: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
569: l_override_type pa_compensation_details.override_type%type;
570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
574: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
575: l_ot_project_id pa_projects_all.project_id%type;
576: l_ot_task_id pa_tasks.task_id%type;

Line 573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

569: l_override_type pa_compensation_details.override_type%type;
570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
574: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
575: l_ot_project_id pa_projects_all.project_id%type;
576: l_ot_task_id pa_tasks.task_id%type;
577: l_err_code varchar2(200);

Line 574: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;

570: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
571: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
572: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
573: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
574: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
575: l_ot_project_id pa_projects_all.project_id%type;
576: l_ot_task_id pa_tasks.task_id%type;
577: l_err_code varchar2(200);
578: l_err_stage number;

Line 614: pa_compensation_details cd

610: cd.hourly_cost_rate
611: INTO
612: X_cost_rate
613: FROM
614: pa_compensation_details cd
615: WHERE
616: cd.person_id = X_person_id
617: AND X_date BETWEEN cd.start_date_active
618: AND nvl( cd.end_date_active, X_date );