DBA Data[Home] [Help]

APPS.HR_ACCRUAL_PLAN_API dependencies on FF_ROUTES

Line 575: FROM ff_routes fr

571: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
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'

Line 585: FROM ff_routes fr

581: ,'TAX_UNIT_ID')
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'

Line 602: FROM ff_routes fr

598: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
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'