APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_DIMENSION_ROUTES

Line 746: pay_dimension_routes pdr

742: AND c.legislation_code = 'ZZ'
743: UNION
744: SELECT NULL
745: FROM pay_balance_dimensions pbd,
746: pay_dimension_routes pdr
747: WHERE pbd.legislation_code = 'ZZ'
748: and pdr.balance_dimension_id = pbd.balance_dimension_id
749: and pdr.route_id = a.route_id);
750:

Line 793: FROM pay_dimension_routes pdr

789: pdr.balance_dimension_id ,pdr.route_id ,pdr.route_type ,pdr.priority ,pdr.run_dimension_id ,
790: pdr.balance_type_column ,pdr.decode_required ,pdr.last_update_date ,pdr.last_updated_by ,
791: pdr.last_update_login ,pdr.created_by ,pdr.creation_date ,pdr.object_version_number ,
792: pbd.dimension_name
793: FROM pay_dimension_routes pdr
794: ,pay_balance_dimensions pbd
795: WHERE nvl(pbd.legislation_code,'X') = 'ZZ'
796: AND pbd.business_group_id IS NULL
797: AND pbd.balance_dimension_id = pdr.balance_dimension_id;

Line 862: ,pay_dimension_routes pdr

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
865: AND ao.key_name = 'ROUTE_ID'
866: AND TO_NUMBER(ao.key_value) = fr.route_id

Line 3158: or pay_dimension_routes for existing balance dimensions

3154: hr_utility.set_location('pay_ip_startup_util.setup',10);
3155:
3156: /* Change the values of these patch variables whenever
3157: a patch updating route_id in table pay_balance_dimensions
3158: or pay_dimension_routes for existing balance dimensions
3159: or balance dimension routes is delivered.
3160: */
3161: lv_patch_name := 'ENABLE_RUN_BALANCES';
3162: lv_appl_release := '121';