DBA Data[Home] [Help]

APPS.PAY_PBA_BUS dependencies on PAY_DEFINED_BALANCES

Line 479: from pay_defined_balances pdb

475: cursor csr_chk_def_bal_id_u(p_leg_code varchar2
476: ,p_bg_id number)
477: is
478: select 1
479: from pay_defined_balances pdb
480: where pdb.defined_balance_id = p_defined_balance_id
481: and ((pdb.business_group_id is not null
482: and pdb.business_group_id = p_bg_id)
483: or (pdb.legislation_code is not null

Line 491: from pay_defined_balances pdb

487: --
488: cursor csr_chk_def_bal_id_s(p_leg_code varchar2)
489: is
490: select 1
491: from pay_defined_balances pdb
492: where pdb.defined_balance_id = p_defined_balance_id
493: and pdb.business_group_id is null
494: and ((pdb.legislation_code is not null
495: and pdb.legislation_code = p_leg_code)

Line 501: from pay_defined_balances pdb

497: --
498: cursor csr_chk_def_bal_id_g
499: is
500: select 1
501: from pay_defined_balances pdb
502: where pdb.defined_balance_id = p_defined_balance_id
503: and pdb.business_group_id is null
504: and pdb.legislation_code is null;
505: --