DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on FND_PROFILE

Line 2568: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

2564: AND person_id = p_person_id
2565: AND date_start = (SELECT MAX(TO_DATE(date_start,'DD-MM-YY'))
2566: FROM per_periods_of_service
2567: WHERE person_id = p_person_id
2568: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2569: );
2570:
2571: --Cursor to find the asg end date
2572: CURSOR csr_asg_effective_date(p_assignment_id NUMBER