[Home] [Help]
410: RETURN Number IS
411: --
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
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
883: AND pbt.balance_name = 'FR_SICKNESS_IJSS_REFERENCE_SALARY'
884: AND pbd.database_item_suffix = '_ASG_PTD'
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
2503: AND pbt.balance_name = p_balance_name
2504: AND pbd.database_item_suffix = '_ASG_PTD'
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
3511: AND pbt.balance_name = p_balance_name
3512: AND pbd.dimension_name = 'Assignment Proration Run To Date'
4245: IS
4246: --
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