DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on FF_ROUTES

Line 738: FROM ff_routes a

734: CURSOR get_routes_csr IS
735: SELECT
736: route_id, route_name, user_defined_flag, description, text, last_update_date,
737: last_updated_by, last_update_login, created_by, creation_date, optimizer_hint
738: FROM ff_routes a
739: WHERE EXISTS (SELECT NULL
740: FROM pay_balance_dimensions c
741: WHERE c.route_id = a.route_id
742: AND c.legislation_code = 'ZZ'

Line 849: ,ff_routes fr

845: SELECT ao.key_name
846: ,ao.product_name
847: ,ao.key_value
848: FROM hr_application_ownerships ao
849: ,ff_routes fr
850: ,pay_balance_dimensions pbd
851: WHERE pbd.legislation_code ='ZZ'
852: AND ao.key_name = 'ROUTE_ID'
853: AND TO_NUMBER(ao.key_value) = fr.route_id

Line 860: ,ff_routes fr

856: SELECT ao.key_name
857: ,ao.product_name
858: ,ao.key_value
859: FROM hr_application_ownerships ao
860: ,ff_routes fr
861: ,pay_balance_dimensions pbd
862: ,pay_dimension_routes pdr
863: WHERE pbd.legislation_code ='ZZ'
864: AND pdr.balance_dimension_id = pbd.balance_dimension_id