DBA Data[Home] [Help]

APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 607: pay_balance_dimensions pbd

603: is
604: select pdb.defined_balance_id
605: from pay_defined_balances pdb,
606: pay_balance_types pbt,
607: pay_balance_dimensions pbd
608: where pbt.balance_name = p_balance_name
609: and pbd.dimension_name = p_dimension_name
610: and pbt.balance_type_id = pdb.balance_type_id
611: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 769: pay_balance_dimensions pbd

765: g_ytd_def_bal_tbl,
766: g_bal_name_tbl
767: from pay_balance_types pbt,
768: pay_defined_balances pdb,
769: pay_balance_dimensions pbd
770: where pbt.legislation_code = 'SG'
771: and pbd.legislation_code = pbt.legislation_code
772: and pdb.legislation_code = pbt.legislation_code
773: and pbt.balance_name in ( 'Additional Earnings',

Line 785: pay_balance_dimensions pbd

781: bulk collect into
782: g_mtd_def_bal_tbl
783: from pay_balance_types pbt,
784: pay_defined_balances pdb,
785: pay_balance_dimensions pbd
786: where pbt.legislation_code = 'SG'
787: and pbd.legislation_code = pbt.legislation_code
788: and pdb.legislation_code = pbt.legislation_code
789: and pbt.balance_name in ('Employee CPF Contributions Additional Earnings',