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_RATE_PUB dependencies on PA_STD_BILL_RATE_SCHEDULES

Line 34: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE

30: ,x_start_date_active OUT NOCOPY date
31: ,x_end_date_active OUT NOCOPY date
32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
33: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
34: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
35: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
36: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE

Line 56: l_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;

52: l_num_dummy pa_expenditure_items_all.expenditure_item_id%TYPE;
53:
54: l_override_flag varchar2(1) := 'N' ;
55: l_override_type pa_compensation_details.override_type%TYPE;
56: l_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;
57: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
58: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
59: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;
60: l_curr_org_id pa_expenditures_all.org_id%TYPE; /* Added for bug 7365397 */

Line 57: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;

53:
54: l_override_flag varchar2(1) := 'N' ;
55: l_override_type pa_compensation_details.override_type%TYPE;
56: l_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;
57: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
58: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
59: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;
60: l_curr_org_id pa_expenditures_all.org_id%TYPE; /* Added for bug 7365397 */
61:

Line 412: from pa_std_bill_rate_schedules_all rate_sch

408: ,rate_sch.job_group_id
409: into l_sch_type
410: ,x_cost_rate_curr_code
411: ,l_job_group_id
412: from pa_std_bill_rate_schedules_all rate_sch
413: where rate_sch.bill_rate_sch_id = x_rate_sch_id;
414:
415: l_stage := 'sch type [' || l_sch_type || '] crcc [' || x_cost_rate_curr_code || '] job group [' ||
416: to_char(l_job_group_id) || ']';

Line 528: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE

524: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
525: ,p_calling_module IN varchar2 default 'STAFFED'
526: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
527: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
528: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
529: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
530: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
531: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
532: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE

Line 545: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;

541: l_debug_mode VARCHAR2(1) := 'Y';
542: l_stage VARCHAR2(500);
543:
544: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
545: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
546: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
547: l_ot_project_id pa_projects_all.project_id%TYPE;
548: l_ot_task_id pa_tasks.task_id%TYPE;
549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;

Line 581: from pa_std_bill_rate_schedules_all rate_sch

577: and (assign.org_id = p_org_id or assign.org_id is null)
578: and trunc(p_txn_date) between trunc(assign.start_date_active)
579: and trunc(nvl(assign.end_date_active,p_txn_date))
580: and (exists( select null
581: from pa_std_bill_rate_schedules_all rate_sch
582: ,pa_bill_rates_all bill_rates
583: where rate_sch.bill_rate_sch_id =
584: decode(p_calling_module ,'REQUIREMENT'
585: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)

Line 594: from pa_std_bill_rate_schedules_all rate_sch

590: trunc(nvl(bill_rates.end_date_active,p_txn_date))
591: )
592: or
593: exists( select null
594: from pa_std_bill_rate_schedules_all rate_sch
595: ,pa_bill_rates_all bill_rates
596: where rate_sch.bill_rate_sch_id =
597: decode(p_calling_module ,'REQUIREMENT'
598: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)

Line 822: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;

818: l_acct_cost_rate pa_bill_rates_all.rate%type;
819: l_start_date_active date;
820: l_end_date_active date;
821: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
822: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
823: l_override_type pa_compensation_details.override_type%type;
824: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
825: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
826: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;

Line 992: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;

988: l_cost_rate pa_bill_rates_all.rate%type;
989: l_start_date_active date;
990: l_end_date_active date;
991: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
992: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
993: l_override_type pa_compensation_details.override_type%type;
994: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
995: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
996: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;