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_DEFINED_BALANCES

Line 411: pay_defined_balances pdb_attr,

407: pay_balance_pkg.get_value(fue_live.creator_id,
408: p_ytd_action_id)
409: FROM pay_bal_attribute_definitions pbad,
410: pay_balance_attributes pba,
411: pay_defined_balances pdb_attr,
412: pay_defined_balances pdb_call,
413: pay_balance_dimensions pbd,
414: ff_user_entities fue_live
415: WHERE pbad.attribute_name = 'Year End Balances'

Line 412: pay_defined_balances pdb_call,

408: p_ytd_action_id)
409: FROM pay_bal_attribute_definitions pbad,
410: pay_balance_attributes pba,
411: pay_defined_balances pdb_attr,
412: pay_defined_balances pdb_call,
413: pay_balance_dimensions pbd,
414: ff_user_entities fue_live
415: WHERE pbad.attribute_name = 'Year End Balances'
416: AND pbad.legislation_code = 'MX'

Line 433: FROM pay_defined_balances pdb_call,

429: SELECT DISTINCT
430: fue_live.user_entity_name,
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',

Line 1492: FROM pay_defined_balances pdb_cr,

1488: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1489: cp_ytd_action_id),
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

Line 1493: pay_defined_balances pdb_ncr,

1489: cp_ytd_action_id),
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

Line 1514: FROM pay_defined_balances pdb_cr,

1510: CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
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

Line 1527: FROM pay_defined_balances pdb_ncr,

1523: CURSOR c_get_nonsubsidy(cp_ytd_action_id NUMBER
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

Line 1541: FROM pay_defined_balances pdb_calc,

1537: CURSOR c_get_calc(cp_ytd_action_id NUMBER
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