DBA Data[Home] [Help]

APPS.HR_ACCRUAL_PLAN_API dependencies on FF_ROUTE_CONTEXT_USAGES

Line 577: ,ff_route_context_usages frcu

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

Line 587: ,ff_route_context_usages frcu

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

Line 604: ,ff_route_context_usages frcu

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
608: AND frcu.context_id = fc.context_id);