APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_DIMENSIONS

Line 666: FROM pay_balance_dimensions

662: balance_dimension_id, business_group_id, legislation_code, route_id,
663: database_item_suffix, dimension_name, dimension_type, description,
664: feed_checking_code, feed_checking_type, legislation_subgroup, payments_flag,
665: expiry_checking_code, expiry_checking_level, dimension_level, period_type
666: FROM pay_balance_dimensions
667: WHERE nvl(legislation_code,'X') = 'ZZ'
668: AND business_group_id IS NULL;
669:
670:

Line 677: FROM pay_balance_dimensions c

673: route_id, route_name, user_defined_flag, description, text, last_update_date,
674: last_updated_by, last_update_login, created_by, creation_date
675: FROM ff_routes a
676: WHERE EXISTS (SELECT NULL
677: FROM pay_balance_dimensions c
678: WHERE c.route_id = a.route_id
679: AND c.legislation_code = 'ZZ');
680:
681:

Line 724: ,pay_balance_dimensions pbd

720: SELECT ao.key_name
721: ,ao.product_name
722: ,ao.key_value
723: FROM hr_application_ownerships ao
724: ,pay_balance_dimensions pbd
725: WHERE pbd.legislation_code ='ZZ'
726: AND ao.key_name = 'BALANCE_DIMENSION_ID'
727: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
728: UNION ALL

Line 743: ,pay_balance_dimensions pbd

739: ,ao.product_name
740: ,ao.key_value
741: FROM hr_application_ownerships ao
742: ,ff_routes fr
743: ,pay_balance_dimensions pbd
744: WHERE pbd.legislation_code ='ZZ'
745: AND ao.key_name = 'ROUTE_ID'
746: AND TO_NUMBER(ao.key_value) = fr.route_id
747: AND fr.route_id = pbd.route_id;