APPS.PAY_BAD_BUS dependencies on PAY_BAL_ATTRIBUTE_DEFAULTS

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 613: from pay_bal_attribute_defaults pbd

609: cursor csr_child_defaults(p_bal_att_id number
610: ,p_bg_id number)
611: is
612: select 1
613: from pay_bal_attribute_defaults pbd
614: where pbd.attribute_id = p_bal_att_id
615: and pbd.business_group_id = nvl(p_bg_id, pbd.business_group_id);
616: --
617: cursor get_bg_id

Line 668: -- check for existing child pay_bal_attribute_defaults

664: else
665: close csr_child_attrib;
666: end if;
667: --
668: -- check for existing child pay_bal_attribute_defaults
669: --
670: open csr_child_defaults(p_attribute_id, each_bg.business_group_id);
671: fetch csr_child_defaults into l_exists;
672: if csr_child_defaults%FOUND then