eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_YREND_ARCH dependencies on PAY_BALANCE_DIMENSIONS

Line 272: pay_balance_dimensions pbd,

268: FROM pay_bal_attribute_definitions pbad,
269: pay_balance_attributes pba,
270: pay_defined_balances pdb_attr,
271: pay_defined_balances pdb_call,
272: pay_balance_dimensions pbd,
273: ff_user_entities fue_live
274: WHERE pbad.attribute_name = 'Year End Balances'
275: AND pbad.legislation_code = 'MX'
276: AND pba.attribute_id = pbad.attribute_id

Line 293: pay_balance_dimensions pbd,

289: fue_live.user_entity_name,
290: fue_live.creator_id,
291: 0 tmp_bal_value
292: FROM pay_defined_balances pdb_call,
293: pay_balance_dimensions pbd,
294: pay_balance_types pbt,
295: ff_user_entities fue_live
296: WHERE pbt.balance_name IN ('ISR Withheld',
297: 'Year End ISR Subject for Profit Sharing',

Line 1742: pay_balance_dimensions pbd

1738: FROM pay_defined_balances pdb_cr,
1739: pay_defined_balances pdb_ncr,
1740: pay_balance_types pbt_cr,
1741: pay_balance_types pbt_ncr,
1742: pay_balance_dimensions pbd
1743: WHERE pdb_cr.balance_type_id = pbt_cr.balance_type_id
1744: AND pdb_ncr.balance_type_id = pbt_ncr.balance_type_id
1745: AND pdb_cr.balance_dimension_id = pbd.balance_dimension_id
1746: AND pdb_ncr.balance_dimension_id = pbd.balance_dimension_id

Line 1762: pay_balance_dimensions pbd

1758: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1759: cp_ytd_action_id)
1760: FROM pay_defined_balances pdb_cr,
1761: pay_balance_types pbt_cr,
1762: pay_balance_dimensions pbd
1763: WHERE pdb_cr.balance_type_id = pbt_cr.balance_type_id
1764: AND pdb_cr.balance_dimension_id = pbd.balance_dimension_id
1765: AND pbt_cr.balance_name = 'ISR Creditable Subsidy'
1766: AND pbd.database_item_suffix = '_PER_PDS_GRE_YTD'

Line 1775: pay_balance_dimensions pbd

1771: select pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1772: cp_ytd_action_id)
1773: FROM pay_defined_balances pdb_ncr,
1774: pay_balance_types pbt_ncr,
1775: pay_balance_dimensions pbd
1776: WHERE pdb_ncr.balance_type_id = pbt_ncr.balance_type_id
1777: AND pdb_ncr.balance_dimension_id = pbd.balance_dimension_id
1778: AND pbt_ncr.balance_name = 'ISR Non Creditable Subsidy'
1779: AND pbd.database_item_suffix = '_PER_PDS_GRE_YTD'

Line 1789: pay_balance_dimensions pbd

1785: select pay_balance_pkg.get_value(pdb_calc.defined_balance_id,
1786: cp_ytd_action_id)
1787: FROM pay_defined_balances pdb_calc,
1788: pay_balance_types pbt_calc,
1789: pay_balance_dimensions pbd
1790: WHERE pdb_calc.balance_type_id = pbt_calc.balance_type_id
1791: AND pdb_calc.balance_dimension_id = pbd.balance_dimension_id
1792: AND pbt_calc.balance_name = 'ISR Calculated'
1793: AND pbd.database_item_suffix = '_PER_PDS_GRE_YTD'