DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 144: pay_balance_dimensions pbd,

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

Line 509: pay_balance_dimensions pbd,

505: CURSOR csr_balance_dimension(p_balance IN CHAR,
506: p_dimension IN CHAR) IS
507: SELECT pdb.defined_balance_id
508: FROM pay_balance_types pbt,
509: pay_balance_dimensions pbd,
510: pay_defined_balances pdb
511: WHERE pdb.balance_type_id = pbt.balance_type_id
512: AND pdb.balance_dimension_id = pbd.balance_dimension_id
513: AND pbt.balance_name = p_balance