APPS.HR_US_REPORTS dependencies on PAY_BALANCE_TYPES

Line 1000: , pay_balance_types pbt

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')
1004: OR pbt.business_group_id + 0 = p_business_group_id)

Line 1042: , pay_balance_types pbt

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
1046: AND pdb.balance_dimension_id = pbd.balance_dimension_id;

Line 1091: FROM pay_balance_types pbt

1087: --
1088: begin
1089: SELECT pbt.balance_type_id
1090: INTO l_balance_type_id
1091: FROM pay_balance_types pbt
1092: WHERE pbt.balance_name = l_balance_type_name
1093: AND pbt.business_group_id is null
1094: AND pbt.legislation_code = 'US';
1095: exception

Line 1106: , pay_balance_types pbt

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
1110: AND pdb.balance_dimension_id = pbd.balance_dimension_id;