DBA Data[Home] [Help]

APPS.HR_ACCRUAL_PLAN_API dependencies on FF_CONTEXTS

Line 576: ,ff_contexts fc

572: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
573: = NVL(l_legislation_code, hr_api.g_varchar2)
574: AND EXISTS (SELECT NULL
575: FROM ff_routes fr
576: ,ff_contexts fc
577: ,ff_route_context_usages frcu
578: WHERE fr.route_id = pbd.route_id
579: AND fc.context_name IN ('ASSIGNMENT_ACTION_ID'
580: ,'DATE_EARNED'

Line 586: ,ff_contexts fc

582: AND frcu.route_id = fr.route_id
583: AND frcu.context_id = fc.context_id)
584: AND NOT EXISTS (SELECT NULL
585: FROM ff_routes fr
586: ,ff_contexts fc
587: ,ff_route_context_usages frcu
588: WHERE fr.route_id = pbd.route_id
589: AND fc.context_name NOT IN ('ASSIGNMENT_ACTION_ID'
590: ,'DATE_EARNED'

Line 603: ,ff_contexts fc

599: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
600: = NVL(l_legislation_code, hr_api.g_varchar2)
601: AND EXISTS (SELECT NULL
602: FROM ff_routes fr
603: ,ff_contexts fc
604: ,ff_route_context_usages frcu
605: WHERE fr.route_id = pbd.route_id
606: AND fc.context_name = 'JURISDICTION_CODE'
607: AND frcu.route_id = fr.route_id