APPS.BEN_REG_BUS dependencies on BEN_REGN_F

Line 122: from ben_regn_f

118: --
119: --
120: cursor csr_name is
121: select null
122: from ben_regn_f
123: where name = p_name
124: and regn_id <> nvl(p_regn_id, hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
126: and p_validation_start_date <= effective_end_date

Line 344: (p_base_table_name => 'ben_regn_for_regy_body_f',

340: l_table_name := 'ben_pl_regn_f';
341: Raise l_rows_exist;
342: End If;
343: If (dt_api.rows_exist
344: (p_base_table_name => 'ben_regn_for_regy_body_f',
345: p_base_key_column => 'regn_id',
346: p_base_key_value => p_regn_id,
347: p_from_date => p_validation_start_date,
348: p_to_date => p_validation_end_date)) Then

Line 349: l_table_name := 'ben_regn_for_regy_body_f';

345: p_base_key_column => 'regn_id',
346: p_base_key_value => p_regn_id,
347: p_from_date => p_validation_start_date,
348: p_to_date => p_validation_end_date)) Then
349: l_table_name := 'ben_regn_for_regy_body_f';
350: Raise l_rows_exist;
351: End If;
352: --
353: End If;

Line 498: ben_regn_f b

494: --
495: cursor csr_leg_code is
496: select a.legislation_code
497: from per_business_groups a,
498: ben_regn_f b
499: where b.regn_id = p_regn_id
500: and a.business_group_id = b.business_group_id;
501: --
502: -- Declare local variables