DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_CROSS_BUSINESS_GRP

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

536: if ( l_debug_mode = 'Y' )
537: then
538: pa_cc_utils.log_message(l_stage);
539: end if;
540: l_dest_job_id := pa_cross_business_grp.IsMappedToJob(x_job_id, l_job_group_id);
541:
542: l_stage := 'Getting rate for job id [' || to_char(l_dest_job_id) || ']';
543: if ( l_debug_mode = 'Y' )
544: then

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

754: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)
755: and bill_rates.bill_rate_sch_id = rate_sch.bill_rate_sch_id
756: and rate_sch.schedule_type = 'JOB'
757: and bill_rates.job_id =
758: pa_cross_business_grp.IsMappedToJob(p_job_id, rate_sch.job_group_id)
759: and trunc(p_txn_date) between trunc(bill_rates.start_date_active) and
760: trunc(nvl(bill_rates.end_date_active,p_txn_date))
761: )
762: )