DBA Data[Home] [Help]

APPS.BEN_RRB_BUS dependencies on BEN_REGN_FOR_REGY_BODY_F

Line 194: from ben_regn_for_regy_body_f

190: --
191: --
192: cursor csr_organization_id is
193: select null
194: from ben_regn_for_regy_body_f
195: where organization_id = p_organization_id
196: and regn_id = p_regn_id
197: and regn_for_regy_body_id <> nvl(p_regn_for_regy_body_id,hr_api.g_number)
198: and business_group_id + 0 = p_business_group_id

Line 579: ben_regn_for_regy_body_f b

575: --
576: cursor csr_leg_code is
577: select a.legislation_code
578: from per_business_groups a,
579: ben_regn_for_regy_body_f b
580: where b.regn_for_regy_body_id = p_regn_for_regy_body_id
581: and a.business_group_id = b.business_group_id;
582: --
583: -- Declare local variables