DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 310: FROM pa_std_bill_rate_schedules_all sch

306: Cursor cur_nlr_sch_details IS
307: SELECT sch.rate_sch_currency_code
308: ,rates.rate
309: ,rates.markup_percentage
310: FROM pa_std_bill_rate_schedules_all sch
311: ,pa_bill_rates_all rates
312: WHERE sch.bill_rate_sch_id = p_rate_sch_id
313: AND sch.schedule_type = 'NON-LABOR'
314: AND rates.bill_rate_sch_id = sch.bill_rate_sch_id

Line 328: FROM pa_std_bill_rate_schedules_all sch

324: Cursor cur_emp_sch_details IS
325: SELECT sch.rate_sch_currency_code
326: ,rates.rate
327: ,rates.markup_percentage
328: FROM pa_std_bill_rate_schedules_all sch
329: ,pa_bill_rates_all rates
330: WHERE sch.bill_rate_sch_id = p_rate_sch_id
331: AND sch.schedule_type = 'EMPLOYEE'
332: AND rates.person_id = p_person_id

Line 341: FROM pa_std_bill_rate_schedules_all sch

337: Cursor cur_job_sch_details IS
338: SELECT sch.rate_sch_currency_code
339: ,rates.rate
340: ,rates.markup_percentage
341: FROM pa_std_bill_rate_schedules_all sch
342: ,pa_bill_rates_all rates
343: WHERE sch.bill_rate_sch_id = p_rate_sch_id
344: AND sch.schedule_type = 'JOB'
345: AND rates.job_id = pa_cross_business_grp.IsMappedToJob(p_job_id, rates.job_group_id)

Line 1904: FROM pa_std_bill_rate_schedules_all sch

1900:
1901: Cursor cur_nlr_sch_details IS
1902: SELECT sch.rate_sch_currency_code
1903: ,rates.rate
1904: FROM pa_std_bill_rate_schedules_all sch
1905: ,pa_bill_rates_all rates
1906: WHERE sch.bill_rate_sch_id = p_nlr_schedule_id
1907: AND sch.schedule_type = 'NON-LABOR'
1908: AND rates.bill_rate_sch_id = sch.bill_rate_sch_id