APPS.HR_US_REPORTS dependencies on PAY_BALANCE_TYPES

Line 1018: , pay_balance_types pbt

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

Line 1060: , pay_balance_types pbt

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

Line 1109: FROM pay_balance_types pbt

1105: --
1106: begin
1107: SELECT pbt.balance_type_id
1108: INTO l_balance_type_id
1109: FROM pay_balance_types pbt
1110: WHERE pbt.balance_name = l_balance_type_name
1111: AND pbt.business_group_id is null
1112: AND pbt.legislation_code = 'US';
1113: exception

Line 1124: , pay_balance_types pbt

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