DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_CROSS_BUSINESS_GRP

Line 453: l_dest_job_id := pa_cross_business_grp.IsMappedToJob(x_job_id, l_job_group_id);

449: if ( l_debug_mode = 'Y' )
450: then
451: pa_cc_utils.log_message(l_stage);
452: end if;
453: l_dest_job_id := pa_cross_business_grp.IsMappedToJob(x_job_id, l_job_group_id);
454:
455: l_stage := 'Getting rate for job id [' || to_char(l_dest_job_id) || ']';
456: if ( l_debug_mode = 'Y' )
457: then

Line 602: pa_cross_business_grp.IsMappedToJob(p_job_id, rate_sch.job_group_id)

598: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)
599: and bill_rates.bill_rate_sch_id = rate_sch.bill_rate_sch_id
600: and rate_sch.schedule_type = 'JOB'
601: and bill_rates.job_id =
602: pa_cross_business_grp.IsMappedToJob(p_job_id, rate_sch.job_group_id)
603: and trunc(p_txn_date) between trunc(bill_rates.start_date_active) and
604: trunc(nvl(bill_rates.end_date_active,p_txn_date))
605: )
606: )