APPS.HR_US_REPORTS dependencies on PAY_DEFINED_BALANCES

Line 998: FROM pay_defined_balances pdb

994: /* Legislation code is added in this query so that it does not
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

Line 1040: FROM pay_defined_balances pdb

1036: begin
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

Line 1104: FROM pay_defined_balances pdb

1100: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',10);
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