APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_BALANCE_DIMENSIONS

Line 415: , pay_balance_dimensions bd

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
419: and bt.balance_name = p_balance_name

Line 879: pay_balance_dimensions pbd,

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
883: AND pbt.balance_name = 'FR_SICKNESS_IJSS_REFERENCE_SALARY'

Line 2499: pay_balance_dimensions pbd,

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
2503: AND pbt.balance_name = p_balance_name

Line 3507: pay_balance_dimensions pbd,

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
3511: AND pbt.balance_name = p_balance_name

Line 4250: , pay_balance_dimensions bd

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
4254: and bt.balance_name = p_balance_name