129: pa.effective_start_date AND
130: pa.effective_end_date /* Removed the nvl on end_date as part of Assignment Type Validation changes for bug 2911451 */
131: AND b.bill_rate_sch_id = p_bill_rate_sch_id(i)
132: AND b.bill_rate_sch_id = brs.bill_rate_sch_id
133: AND b.job_id = PA_cross_Business_Grp.IsMappedToJob(pa.job_id, brs.job_group_id)
134: AND nvl(p_fixed_date(i),p_expenditure_item_date(i)) BETWEEN
135: b.start_date_active AND nvl(b.end_date_active,p_expenditure_item_date(i));
136:
137: x_tp_job_id(I) := v_job_id;