DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 142: pay_balance_dimensions pbd,

138: pbd.database_item_suffix,
139: pbt.legislation_code,
140: pdb.defined_balance_id
141: FROM pay_balance_types pbt,
142: pay_balance_dimensions pbd,
143: pay_defined_balances pdb
144: WHERE pdb.balance_type_id = pbt.balance_type_id
145: AND pdb.balance_dimension_id = pbd.balance_dimension_id
146: AND pbt.balance_type_id = p_balance_type_id

Line 472: pay_balance_dimensions pbd,

468: CURSOR csr_balance_dimension(p_balance IN CHAR,
469: p_dimension IN CHAR) IS
470: SELECT pdb.defined_balance_id
471: FROM pay_balance_types pbt,
472: pay_balance_dimensions pbd,
473: pay_defined_balances pdb
474: WHERE pdb.balance_type_id = pbt.balance_type_id
475: AND pdb.balance_dimension_id = pbd.balance_dimension_id
476: AND pbt.balance_name = p_balance