APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 291: pay_balance_dimensions pbd,

287: pbd.database_item_suffix,
288: pbt.legislation_code,
289: pdb.defined_balance_id
290: FROM pay_balance_types pbt,
291: pay_balance_dimensions pbd,
292: pay_defined_balances pdb
293: WHERE pdb.balance_type_id = pbt.balance_type_id
294: AND pdb.balance_dimension_id = pbd.balance_dimension_id
295: AND pbt.balance_type_id = p_balance_type_id

Line 701: pay_balance_dimensions pbd,

697: CURSOR csr_balance_dimension(p_balance IN CHAR,
698: p_dimension IN CHAR) IS
699: SELECT pdb.defined_balance_id
700: FROM pay_balance_types pbt,
701: pay_balance_dimensions pbd,
702: pay_defined_balances pdb
703: WHERE pdb.balance_type_id = pbt.balance_type_id
704: AND pdb.balance_dimension_id = pbd.balance_dimension_id
705: AND pbt.balance_name = p_balance

Line 967: pay_balance_dimensions pbd

963: CURSOR csr_get_prsi_week_id IS
964: SELECT pdb.defined_balance_id
965: FROM pay_defined_balances pdb,
966: pay_balance_types pbt,
967: pay_balance_dimensions pbd
968: WHERE pbd.dimension_name = '_ASG_YTD'
969: AND pbd.legislation_code = 'IE'
970: AND pbt.balance_name = 'IE PRSI Insurable Weeks'
971: AND pbt.legislation_code = 'IE'