DBA Data[Home] [Help]

APPS.PER_ASG_AGGR dependencies on PAY_BALANCE_TYPES

Line 630: FROM pay_balance_types

626: CURSOR cur_defined_balance(c_balance_name varchar2, c_dimension_name varchar2) IS
627: SELECT defined_balance_id
628: FROM pay_defined_balances
629: WHERE balance_type_id = (SELECT balance_type_id
630: FROM pay_balance_types
631: WHERE balance_name = c_balance_name AND legislation_code = 'GB')
632: AND balance_dimension_id = (SELECT balance_dimension_id
633: FROM pay_balance_dimensions
634: WHERE dimension_name = c_dimension_name AND legislation_code = 'GB');