DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on HR_GENERAL

Line 557: AND ass.business_group_ID + 0 = NVL(hr_general.get_business_group_id,

553: FROM per_pay_proposals pro1
554: WHERE pro.assignment_id = pro1.assignment_id
555: AND pro1.approved = 'Y'
556: AND pro1.change_date <= l_effective_date)
557: AND ass.business_group_ID + 0 = NVL(hr_general.get_business_group_id,
558: ass.business_group_id)
559: AND l_effective_date BETWEEN per.effective_start_date
560: AND nvl(per.effective_end_date, l_effective_date)
561: AND l_effective_date BETWEEN ass.effective_start_date