DBA Data[Home] [Help]

APPS.PAY_BAD_BUS dependencies on PAY_BALANCE_ATTRIBUTES

Line 576: -- pay_balance_attributes and pay_bal_attribute_defaults.

572: --
573: -- Description:
574: -- This procedure is used to ensure that no child rows exist when attempting
575: -- to delete a row from this table. Child row could exist in tables
576: -- pay_balance_attributes and pay_bal_attribute_defaults.
577: --
578: -- Pre Conditions:
579: -- g_old_rec has been populated with details of the values currently in
580: -- the database.

Line 605: from pay_balance_attributes pba

601: cursor csr_child_attrib(p_bal_att_id number
602: ,p_bg_id number)
603: is
604: select 1
605: from pay_balance_attributes pba
606: where pba.attribute_id = p_bal_att_id
607: and pba.business_group_id = nvl(p_bg_id, pba.business_group_id);
608: --
609: cursor csr_child_defaults(p_bal_att_id number