APPS.PA_COST_RATE_PUB dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

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: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE; /* added for 12.2 . bug 10253400 */

Line 499: from pa_std_bill_rate_schedules_all rate_sch

495: ,rate_sch.job_group_id
496: into l_sch_type
497: ,x_cost_rate_curr_code
498: ,l_job_group_id
499: from pa_std_bill_rate_schedules_all rate_sch
500: where rate_sch.bill_rate_sch_id = x_rate_sch_id;
501:
502: l_stage := 'sch type [' || l_sch_type || '] crcc [' || x_cost_rate_curr_code || '] job group [' ||
503: to_char(l_job_group_id) || ']';

Line 737: from pa_std_bill_rate_schedules_all rate_sch

733: and (assign.org_id = p_org_id or assign.org_id is null)
734: and trunc(p_txn_date) between trunc(assign.start_date_active)
735: and trunc(nvl(assign.end_date_active,p_txn_date))
736: and (exists( select null
737: from pa_std_bill_rate_schedules_all rate_sch
738: ,pa_bill_rates_all bill_rates
739: where rate_sch.bill_rate_sch_id =
740: decode(p_calling_module ,'REQUIREMENT'
741: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)

Line 750: from pa_std_bill_rate_schedules_all rate_sch

746: trunc(nvl(bill_rates.end_date_active,p_txn_date))
747: )
748: or
749: exists( select null
750: from pa_std_bill_rate_schedules_all rate_sch
751: ,pa_bill_rates_all bill_rates
752: where rate_sch.bill_rate_sch_id =
753: decode(p_calling_module ,'REQUIREMENT'
754: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)