APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 1547: pay_balance_dimensions pbd,

1543:
1544: CURSOR get_defined_balance_details IS
1545: SELECT pbt.balance_name,pbd.dimension_name
1546: FROM pay_balance_types pbt,
1547: pay_balance_dimensions pbd,
1548: pay_defined_balances pdb
1549: WHERE pbt.balance_name in
1550: ('City PSD Subj Whable',
1551: 'City PSD Withheld',

Line 1574: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

1570: l_business_group_id pay_balance_validation.business_group_id%TYPE;
1571: l_print_business_group_id pay_balance_validation.business_group_id%TYPE;
1572: l_business_group_name per_business_groups.name%TYPE;
1573: l_balance_name pay_balance_types.balance_name%TYPE;
1574: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
1575: l_balance_validation_id pay_balance_validation.balance_validation_id%TYPE;
1576: l_balance_load_date DATE;
1577:
1578: BEGIN