DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 29: g_rt_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;

25: g_rt_start_date_active date;
26: g_rt_end_date_active date;
27: g_rt_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
28: g_rt_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
29: g_rt_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;
30: g_rt_cost_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
31: g_rt_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
32: g_rt_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
33: g_rt_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;

Line 40: g_rt_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;

36: g_rt_err_stage number;
37: g_rt_err_code varchar2(50);
38: g_rt_person_id pa_bill_rates_all.person_id%TYPE;
39: g_rt_job_id pa_bill_rates_all.job_id%TYPE;
40: g_rt_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;
41:
42:
43: -- Start of comments
44: -- API name : get_labor_rate

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

69: ,x_start_date_active OUT NOCOPY date
70: ,x_end_date_active OUT NOCOPY date
71: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
72: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
73: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
74: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
75: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
76: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
77: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE