APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 137: pay_balance_dimensions pbd,

133: pbd.database_item_suffix,
134: pbt.legislation_code,
135: pdb.defined_balance_id
136: FROM pay_balance_types pbt,
137: pay_balance_dimensions pbd,
138: pay_defined_balances pdb
139: WHERE pdb.balance_type_id = pbt.balance_type_id
140: AND pdb.balance_dimension_id = pbd.balance_dimension_id
141: AND pbt.balance_type_id = p_balance_type_id

Line 544: pay_balance_dimensions pbd,

540: CURSOR csr_balance_dimension(p_balance IN CHAR,
541: p_dimension IN CHAR) IS
542: SELECT pdb.defined_balance_id
543: FROM pay_balance_types pbt,
544: pay_balance_dimensions pbd,
545: pay_defined_balances pdb
546: WHERE pdb.balance_type_id = pbt.balance_type_id
547: AND pdb.balance_dimension_id = pbd.balance_dimension_id
548: AND pbt.balance_name = p_balance

Line 778: pay_balance_dimensions pbd

774: CURSOR csr_get_prsi_week_id IS
775: SELECT pdb.defined_balance_id
776: FROM pay_defined_balances pdb,
777: pay_balance_types pbt,
778: pay_balance_dimensions pbd
779: WHERE pbd.dimension_name = '_ASG_YTD'
780: AND pbd.legislation_code = 'IE'
781: AND pbt.balance_name = 'IE PRSI Insurable Weeks'
782: AND pbt.legislation_code = 'IE'