DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on FND_PROFILE

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

2776: AND person_id = p_person_id
2777: AND date_start = (SELECT MAX(TO_DATE(date_start,'DD-MM-YY'))
2778: FROM per_periods_of_service
2779: WHERE person_id = p_person_id
2780: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2781: );
2782:
2783: --Cursor to find the asg end date
2784: CURSOR csr_asg_effective_date(p_assignment_id NUMBER