DBA Data[Home] [Help]

APPS.PAY_PBC_BUS dependencies on PAY_BAL_ATTRIBUTE_DEFAULTS

Line 715: from pay_bal_attribute_defaults pbd

711: cursor csr_child_defaults(p_bal_cat_id number
712: ,p_bg_id number)
713: is
714: select 1
715: from pay_bal_attribute_defaults pbd
716: where pbd.balance_category_id = p_bal_cat_id
717: and pbd.business_group_id = nvl(p_bg_id, pbd.business_group_id);
718: --
719: cursor get_bg_id

Line 747: -- check for existing child pay_bal_attribute_defaults

743: else
744: close csr_child_balance;
745: end if;
746: --
747: -- check for existing child pay_bal_attribute_defaults
748: --
749: open csr_child_defaults(p_balance_category_id, each_bg.business_group_id);
750: fetch csr_child_defaults into l_exists;
751: if csr_child_defaults%FOUND then