DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on PAY_DEFINED_BALANCES

Line 1016: FROM pay_defined_balances pdb

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

Line 1058: FROM pay_defined_balances pdb

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

Line 1122: FROM pay_defined_balances pdb

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