APPS.PA_BILL_SCHEDULE dependencies on PA_BILL_RATES_ALL

Line 34: bill_rate pa_bill_rates_all.rate%TYPE;

30: IS
31: /*-----------------------------------------------------------------------------
32: declare all the variables.
33: ----------------------------------------------------------------------------*/
34: bill_rate pa_bill_rates_all.rate%TYPE;
35: markup pa_bill_rates_all.markup_percentage%TYPE;
36: bill_ous pa_bill_rates_all.org_id%TYPE;
37: v_job_id pa_bill_rates_all.job_id%TYPE;
38: v_curr_code pa_bill_rates_all.rate_currency_code%TYPE; -- Added this column for MCB2

Line 35: markup pa_bill_rates_all.markup_percentage%TYPE;

31: /*-----------------------------------------------------------------------------
32: declare all the variables.
33: ----------------------------------------------------------------------------*/
34: bill_rate pa_bill_rates_all.rate%TYPE;
35: markup pa_bill_rates_all.markup_percentage%TYPE;
36: bill_ous pa_bill_rates_all.org_id%TYPE;
37: v_job_id pa_bill_rates_all.job_id%TYPE;
38: v_curr_code pa_bill_rates_all.rate_currency_code%TYPE; -- Added this column for MCB2
39:

Line 36: bill_ous pa_bill_rates_all.org_id%TYPE;

32: declare all the variables.
33: ----------------------------------------------------------------------------*/
34: bill_rate pa_bill_rates_all.rate%TYPE;
35: markup pa_bill_rates_all.markup_percentage%TYPE;
36: bill_ous pa_bill_rates_all.org_id%TYPE;
37: v_job_id pa_bill_rates_all.job_id%TYPE;
38: v_curr_code pa_bill_rates_all.rate_currency_code%TYPE; -- Added this column for MCB2
39:
40:

Line 37: v_job_id pa_bill_rates_all.job_id%TYPE;

33: ----------------------------------------------------------------------------*/
34: bill_rate pa_bill_rates_all.rate%TYPE;
35: markup pa_bill_rates_all.markup_percentage%TYPE;
36: bill_ous pa_bill_rates_all.org_id%TYPE;
37: v_job_id pa_bill_rates_all.job_id%TYPE;
38: v_curr_code pa_bill_rates_all.rate_currency_code%TYPE; -- Added this column for MCB2
39:
40:
41: BEGIN

Line 38: v_curr_code pa_bill_rates_all.rate_currency_code%TYPE; -- Added this column for MCB2

34: bill_rate pa_bill_rates_all.rate%TYPE;
35: markup pa_bill_rates_all.markup_percentage%TYPE;
36: bill_ous pa_bill_rates_all.org_id%TYPE;
37: v_job_id pa_bill_rates_all.job_id%TYPE;
38: v_curr_code pa_bill_rates_all.rate_currency_code%TYPE; -- Added this column for MCB2
39:
40:
41: BEGIN
42: /*-----------------------------------------------------------------------------

Line 73: FROM pa_bill_rates_all b

69: INTO bill_rate,
70: markup,
71: bill_ous,
72: v_curr_code
73: FROM pa_bill_rates_all b
74: WHERE
75: b.bill_rate_sch_id = p_bill_rate_sch_id(i)
76: AND b.expenditure_type = p_expenditure_type(i)
77: AND b.non_labor_resource = p_non_labor_resource(i)

Line 95: FROM pa_bill_rates_all b

91: INTO bill_rate,
92: markup,
93: bill_ous,
94: v_curr_code
95: FROM pa_bill_rates_all b
96: WHERE
97: b.bill_rate_sch_id = p_bill_rate_sch_id(i)
98: AND b.expenditure_type = p_expenditure_type(i)
99: AND b.non_labor_resource IS NULL

Line 120: FROM pa_bill_rates_all b,

116: markup,
117: bill_ous,
118: v_job_id,
119: v_curr_code
120: FROM pa_bill_rates_all b,
121: per_assignments_f pa,
122: pa_std_bill_rate_schedules_all brs
123: WHERE
124: pa.primary_flag = 'Y'

Line 151: FROM pa_bill_rates_all b

147: INTO bill_rate,
148: markup,
149: bill_ous,
150: v_curr_code
151: FROM pa_bill_rates_all b
152: WHERE
153: b.bill_rate_sch_id = p_bill_rate_sch_id(i)
154: AND b.person_id = p_incurred_by_person_id(i)
155: AND nvl(p_fixed_date(i),p_expenditure_item_date(i)) BETWEEN