APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_DEFINED_BALANCES

Line 652: FROM pay_defined_balances d, pay_balance_types b

648: d.defined_balance_id, d.business_group_id, d.legislation_code, d.balance_type_id,
649: d.balance_dimension_id, d.force_latest_balance_flag, d.legislation_subgroup,
650: d.last_update_date, d.last_updated_by, d.last_update_login, d.created_by, d.creation_date,
651: d.object_version_number, d.grossup_allowed_flag, b.balance_name bname
652: FROM pay_defined_balances d, pay_balance_types b
653: WHERE d.balance_type_id = b.balance_type_id
654: AND EXISTS (SELECT NULL FROM hr_s_balance_types b
655: WHERE d.balance_type_id = b.balance_type_id);
656:

Line 733: ,pay_defined_balances pdb

729: SELECT ao.key_name
730: ,ao.product_name
731: ,ao.key_value
732: FROM hr_application_ownerships ao
733: ,pay_defined_balances pdb
734: WHERE pdb.legislation_code ='ZZ'
735: AND ao.key_name = 'DEFINED_BALANCE_ID'
736: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id
737: UNION ALL