APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_DIMENSIONS

Line 729: FROM pay_balance_dimensions

725: database_item_suffix, dimension_name, dimension_type, description,
726: feed_checking_code, feed_checking_type, legislation_subgroup, payments_flag,
727: expiry_checking_code, expiry_checking_level, dimension_level, period_type,
728: save_run_balance_enabled, database_item_function
729: FROM pay_balance_dimensions
730: WHERE nvl(legislation_code,'X') = 'ZZ'
731: AND business_group_id IS NULL;
732:
733:

Line 740: FROM pay_balance_dimensions c

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'
743: UNION
744: SELECT NULL

Line 745: FROM pay_balance_dimensions pbd,

741: WHERE c.route_id = a.route_id
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);

Line 794: ,pay_balance_dimensions pbd

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;
798:

Line 831: ,pay_balance_dimensions pbd

827: SELECT ao.key_name
828: ,ao.product_name
829: ,ao.key_value
830: FROM hr_application_ownerships ao
831: ,pay_balance_dimensions pbd
832: WHERE pbd.legislation_code ='ZZ'
833: AND ao.key_name = 'BALANCE_DIMENSION_ID'
834: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
835: UNION ALL

Line 850: ,pay_balance_dimensions pbd

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
854: AND fr.route_id = pbd.route_id

Line 861: ,pay_balance_dimensions pbd

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
865: AND ao.key_name = 'ROUTE_ID'

Line 3157: a patch updating route_id in table pay_balance_dimensions

3153: BEGIN
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';