APPS.HR_US_REPORTS dependencies on PAY_BALANCE_DIMENSIONS

Line 999: , pay_balance_dimensions pbd

995: fetch multiple values after Canadian Payroll is installed - mmukherj*/
996: SELECT pdb.defined_balance_id
997: INTO l_defined_balance_id
998: FROM pay_defined_balances pdb
999: , pay_balance_dimensions pbd
1000: , pay_balance_types pbt
1001: WHERE pbt.balance_name = p_balance_name
1002: AND ((pbt.business_group_id IS NULL
1003: AND pbt.legislation_code = 'US')

Line 1041: , pay_balance_dimensions pbd

1037: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);
1038: SELECT pdb.defined_balance_id
1039: INTO l_defined_balance_id
1040: FROM pay_defined_balances pdb
1041: , pay_balance_dimensions pbd
1042: , pay_balance_types pbt
1043: WHERE pbt.reporting_name = p_reporting_name
1044: AND pbd.database_item_suffix = p_dimension_suffix
1045: AND pdb.balance_type_id = pbt.balance_type_id

Line 1105: , pay_balance_dimensions pbd

1101: --
1102: SELECT pdb.defined_balance_id
1103: INTO l_defined_balance_id
1104: FROM pay_defined_balances pdb
1105: , pay_balance_dimensions pbd
1106: , pay_balance_types pbt
1107: WHERE pbt.balance_type_id = l_balance_type_id
1108: AND pbd.database_item_suffix = p_dimension_suffix
1109: AND pdb.balance_type_id = pbt.balance_type_id