4587: */
4588: --bug 3068781
4589:
4590: DECLARE
4591: CURSOR cur_job_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4592: WHERE bill_rate_sch_id = l_project_type_rec.job_bill_rate_schedule_id ;
4593:
4594: CURSOR cur_emp_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4595: WHERE bill_rate_sch_id = l_project_type_rec.emp_bill_rate_schedule_id ;
4590: DECLARE
4591: CURSOR cur_job_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4592: WHERE bill_rate_sch_id = l_project_type_rec.job_bill_rate_schedule_id ;
4593:
4594: CURSOR cur_emp_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4595: WHERE bill_rate_sch_id = l_project_type_rec.emp_bill_rate_schedule_id ;
4596:
4597: CURSOR cur_nl_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4598: WHERE bill_rate_sch_id = l_project_type_rec.non_lab_std_bill_rt_sch_id ;
4593:
4594: CURSOR cur_emp_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4595: WHERE bill_rate_sch_id = l_project_type_rec.emp_bill_rate_schedule_id ;
4596:
4597: CURSOR cur_nl_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
4598: WHERE bill_rate_sch_id = l_project_type_rec.non_lab_std_bill_rt_sch_id ;
4599:
4600: CURSOR cur_impl IS SELECT default_rate_type FROM pa_implementations;
4601: