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_FR_GENERAL dependencies on PAY_BALANCE_TYPES

Line 1257: from pay_balance_types pbt

1253: /* The absence records to consider should only be those that feed
1254: the sickness days absence balance */
1255: cursor first_sickness_abs_csr is
1256: select min(paa.date_start)
1257: from pay_balance_types pbt
1258: , pay_balance_feeds_f pbf
1259: , pay_input_values_f piv
1260: , pay_element_types_f pet
1261: , pay_element_entries_f pee

Line 1318: from pay_balance_types pbt

1314: the sickness days absence balance */
1315: cursor count_sickness_abs_csr is
1316: select /*+ USE_NL(pbt pee pee2) */
1317: sum(paa.absence_days)
1318: from pay_balance_types pbt
1319: , pay_balance_feeds_f pbf
1320: , pay_input_values_f piv
1321: , pay_element_types_f pet
1322: , pay_element_entries_f pee

Line 2549: FROM pay_balance_types pbt,

2545: p_balance_end_date in date) return number
2546: IS
2547: Cursor csr_def_bal_id IS
2548: SELECT pdb.defined_balance_id
2549: FROM pay_balance_types pbt,
2550: pay_balance_dimensions pbd,
2551: pay_defined_balances pdb
2552: WHERE pdb.balance_type_id = pbt.balance_type_id
2553: AND pdb.balance_dimension_id = pbd.balance_dimension_id