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_TYPES

Line 435: pay_balance_types pbt,

431: pay_balance_pkg.get_value(fue_live.creator_id,
432: p_ytd_action_id)
433: FROM pay_defined_balances pdb_call,
434: pay_balance_dimensions pbd,
435: pay_balance_types pbt,
436: ff_user_entities fue_live
437: WHERE pbt.balance_name IN ('ISR Withheld',
438: 'Year End ISR Subject for Profit Sharing',
439: 'Year End ISR Exempt for Profit Sharing')

Line 1494: pay_balance_types pbt_cr,

1490: pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1491: cp_ytd_action_id)
1492: FROM pay_defined_balances pdb_cr,
1493: pay_defined_balances pdb_ncr,
1494: pay_balance_types pbt_cr,
1495: pay_balance_types pbt_ncr,
1496: pay_balance_dimensions pbd
1497: WHERE pdb_cr.balance_type_id = pbt_cr.balance_type_id
1498: AND pdb_ncr.balance_type_id = pbt_ncr.balance_type_id

Line 1495: pay_balance_types pbt_ncr,

1491: cp_ytd_action_id)
1492: FROM pay_defined_balances pdb_cr,
1493: pay_defined_balances pdb_ncr,
1494: pay_balance_types pbt_cr,
1495: pay_balance_types pbt_ncr,
1496: pay_balance_dimensions pbd
1497: WHERE pdb_cr.balance_type_id = pbt_cr.balance_type_id
1498: AND pdb_ncr.balance_type_id = pbt_ncr.balance_type_id
1499: AND pdb_cr.balance_dimension_id = pbd.balance_dimension_id

Line 1515: pay_balance_types pbt_cr,

1511: ) IS
1512: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1513: cp_ytd_action_id)
1514: FROM pay_defined_balances pdb_cr,
1515: pay_balance_types pbt_cr,
1516: pay_balance_dimensions pbd
1517: WHERE pdb_cr.balance_type_id = pbt_cr.balance_type_id
1518: AND pdb_cr.balance_dimension_id = pbd.balance_dimension_id
1519: AND pbt_cr.balance_name = 'ISR Creditable Subsidy'

Line 1528: pay_balance_types pbt_ncr,

1524: ) IS
1525: select pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1526: cp_ytd_action_id)
1527: FROM pay_defined_balances pdb_ncr,
1528: pay_balance_types pbt_ncr,
1529: pay_balance_dimensions pbd
1530: WHERE pdb_ncr.balance_type_id = pbt_ncr.balance_type_id
1531: AND pdb_ncr.balance_dimension_id = pbd.balance_dimension_id
1532: AND pbt_ncr.balance_name = 'ISR Non Creditable Subsidy'

Line 1542: pay_balance_types pbt_calc,

1538: ) IS
1539: select pay_balance_pkg.get_value(pdb_calc.defined_balance_id,
1540: cp_ytd_action_id)
1541: FROM pay_defined_balances pdb_calc,
1542: pay_balance_types pbt_calc,
1543: pay_balance_dimensions pbd
1544: WHERE pdb_calc.balance_type_id = pbt_calc.balance_type_id
1545: AND pdb_calc.balance_dimension_id = pbd.balance_dimension_id
1546: AND pbt_calc.balance_name = 'ISR Calculated'

Line 1565: pay_balance_types pbt,

1561: pay_assignment_actions paa,
1562: pay_payroll_actions ppa,
1563: pay_input_values_f piv,
1564: pay_balance_feeds_f pbf,
1565: pay_balance_types pbt,
1566: per_assignments_f paf
1567: WHERE pbt.balance_name = 'Profit Sharing'
1568: AND pbt.legislation_code = 'MX'
1569: AND pbf.balance_type_id = pbt.balance_type_id