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

Line 416: , pay_balance_types bt

412: cursor c_get_defined_balance(p_balance_name varchar2) is
413: select db.defined_balance_id
414: from pay_defined_balances db
415: , pay_balance_dimensions bd
416: , pay_balance_types bt
417: where db.balance_type_id = bt.balance_type_id
418: and db.balance_dimension_id = bd.balance_dimension_id
419: and bt.balance_name = p_balance_name
420: and bt.legislation_code = 'FR'

Line 532: , pay_balance_types bal

528: , pay_balance_feeds_f FEED
529: , pay_run_results RR
530: , pay_assignment_actions ASSACT
531: , pay_payroll_actions PACT
532: , pay_balance_types bal
533: --
534: , pay_assignment_actions sasact
535: , pay_payroll_actions spact
536: , pay_entry_process_details proc

Line 878: FROM pay_balance_types pbt,

874: -- Cursor to find the defined balance id
875: -- of reference salary
876: Cursor csr_ref_bal_id IS
877: SELECT pdb.defined_balance_id
878: FROM pay_balance_types pbt,
879: pay_balance_dimensions pbd,
880: pay_defined_balances pdb
881: WHERE pdb.balance_type_id = pbt.balance_type_id
882: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 2498: FROM pay_balance_types pbt,

2494: p_balance_end_date in date) return number
2495: IS
2496: Cursor csr_def_bal_id IS
2497: SELECT pdb.defined_balance_id
2498: FROM pay_balance_types pbt,
2499: pay_balance_dimensions pbd,
2500: pay_defined_balances pdb
2501: WHERE pdb.balance_type_id = pbt.balance_type_id
2502: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 3506: FROM pay_balance_types_tl pbt,

3502: p_asg in pay_fr_sick_pay_processing.t_asg) return number
3503: IS
3504: Cursor csr_def_bal_id IS
3505: SELECT pdb.defined_balance_id
3506: FROM pay_balance_types_tl pbt,
3507: pay_balance_dimensions pbd,
3508: pay_defined_balances pdb
3509: WHERE pdb.balance_type_id = pbt.balance_type_id
3510: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 4251: , pay_balance_types bt

4247: cursor c_get_defined_balance(p_balance_name VARCHAR2) is
4248: select db.defined_balance_id
4249: from pay_defined_balances db
4250: , pay_balance_dimensions bd
4251: , pay_balance_types bt
4252: where db.balance_type_id = bt.balance_type_id
4253: and db.balance_dimension_id = bd.balance_dimension_id
4254: and bt.balance_name = p_balance_name
4255: and bt.legislation_code = 'FR'