DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_CROSS_BUSINESS_GRP

Line 345: AND rates.job_id = pa_cross_business_grp.IsMappedToJob(p_job_id, rates.job_group_id)

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)
346: AND rates.bill_rate_sch_id = sch.bill_rate_sch_id
347: AND trunc(p_exp_item_date) between trunc(rates.start_date_active)
348: and trunc(nvl(rates.end_date_active,p_exp_item_date));
349: