[Home] [Help]
329: and effective_end_date
330: and business_group_id + 0 = p_business_group_id
331: and TMPRL_FCTR_APLS_RTS_FLAG = 'Y';
332: cursor c2 is select null
333: from ben_pgm_f
334: where pgm_id = p_pgm_id
335: and p_effective_date between effective_start_date
336: and effective_end_date
337: and business_group_id + 0 = p_business_group_id
4602: -- |------< chk_dpnt_dsgn_cd_lvl_dpndcy >------|
4603: -- ----------------------------------------------------------------------------
4604: --
4605: -- Description
4606: -- If dependent designation level from ben_pgm_f is not = 'Plan Type', then the
4607: -- following must be null: Dpnt Dsgn Cd, Cert Req Flag and Derivable Factors Apply Flag.
4608: --
4609: --
4610: -- Pre Conditions
4640: l_api_updating boolean;
4641: l_value varchar2(30);
4642: --
4643: cursor c1 is select pgm.dpnt_dsgn_lvl_cd
4644: from ben_pgm_f pgm
4645: where pgm.pgm_id = p_pgm_id
4646: and pgm.business_group_id + 0 = p_business_group_id
4647: and p_effective_date between pgm.effective_start_date
4648: and pgm.effective_end_date;
4761: p_argument_value => p_validation_end_date);
4762: --
4763: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4764: NOT (dt_api.check_min_max_dates
4765: (p_base_table_name => 'ben_pgm_f',
4766: p_base_key_column => 'pgm_id',
4767: p_base_key_value => p_pgm_id,
4768: p_from_date => p_validation_start_date,
4769: p_to_date => p_validation_end_date))) Then
4766: p_base_key_column => 'pgm_id',
4767: p_base_key_value => p_pgm_id,
4768: p_from_date => p_validation_start_date,
4769: p_to_date => p_validation_end_date))) Then
4770: l_table_name := 'ben_pgm_f';
4771: Raise l_integrity_error;
4772: End If;
4773: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4774: NOT (dt_api.check_min_max_dates