APPS.HR_US_REPORTS dependencies on PAY_BALANCE_DIMENSIONS

Line 1017: , pay_balance_dimensions pbd

1013: fetch multiple values after Canadian Payroll is installed - mmukherj*/
1014: SELECT pdb.defined_balance_id
1015: INTO l_defined_balance_id
1016: FROM pay_defined_balances pdb
1017: , pay_balance_dimensions pbd
1018: , pay_balance_types pbt
1019: WHERE pbt.balance_name = p_balance_name
1020: AND ((pbt.business_group_id IS NULL
1021: AND pbt.legislation_code = 'US')

Line 1059: , pay_balance_dimensions pbd

1055: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);
1056: SELECT pdb.defined_balance_id
1057: INTO l_defined_balance_id
1058: FROM pay_defined_balances pdb
1059: , pay_balance_dimensions pbd
1060: , pay_balance_types pbt
1061: WHERE pbt.reporting_name = p_reporting_name
1062: AND pbd.database_item_suffix = p_dimension_suffix
1063: AND pdb.balance_type_id = pbt.balance_type_id

Line 1123: , pay_balance_dimensions pbd

1119: --
1120: SELECT pdb.defined_balance_id
1121: INTO l_defined_balance_id
1122: FROM pay_defined_balances pdb
1123: , pay_balance_dimensions pbd
1124: , pay_balance_types pbt
1125: WHERE pbt.balance_type_id = l_balance_type_id
1126: AND pbd.database_item_suffix = p_dimension_suffix
1127: AND pdb.balance_type_id = pbt.balance_type_id