APPS.BEN_PGM_BUS dependencies on BEN_PTIP_F

Line 5480: -- from BEN_PTIP_F must be null: Dpnt Designation, Cert req

5476: -- ----------------------------------------------------------------------------
5477: --
5478: -- Description
5479: -- If dependent designation level is not 'Plan Type' the following fields
5480: -- from BEN_PTIP_F must be null: Dpnt Designation, Cert req
5481: -- Derivable factors apply flag.
5482: --
5483: --
5484: -- Pre Conditions

Line 5516: from ben_ptip_f ctp

5512: l_api_updating boolean;
5513: l_dummy varchar2(30);
5514: --
5515: cursor c1 is select null
5516: from ben_ptip_f ctp
5517: where ctp.pgm_id = p_pgm_id
5518: and (ctp.dpnt_dsgn_cd is not null or
5519: ctp.drvd_fctr_dpnt_cvg_flag = 'Y' or
5520: ctp.dpnt_dsgn_no_cvg_ctfn_rqd = 'Y')

Line 5603: from BEN_PTIP_F ctp,

5599: l_api_updating boolean;
5600: l_dummy varchar2(30);
5601: --
5602: cursor c1 is select null
5603: from BEN_PTIP_F ctp,
5604: BEN_LER_CHG_DPNT_CVG_F ldc
5605: where ctp.pgm_id = p_pgm_id
5606: and ctp.business_group_id +0 = p_business_group_id
5607: and p_effective_date between ctp.effective_start_date

Line 5615: from BEN_PTIP_F ctp,

5611: and p_effective_date between ldc.effective_start_date
5612: and ldc.effective_end_date;
5613: --
5614: cursor c2 is select null
5615: from BEN_PTIP_F ctp,
5616: BEN_APLD_DPNT_CVG_ELIG_PRFL_F ade
5617: where ctp.pgm_id = p_pgm_id
5618: and ctp.business_group_id +0 = p_business_group_id
5619: and p_effective_date between ctp.effective_start_date

Line 5627: from BEN_PTIP_F ctp,

5623: and p_effective_date between ade.effective_start_date
5624: and ade.effective_end_date;
5625: --
5626: cursor c3 is select null
5627: from BEN_PTIP_F ctp,
5628: BEN_PTIP_DPNT_CVG_CTFN_F pyd
5629: where ctp.pgm_id = p_pgm_id
5630: and ctp.business_group_id +0 = p_business_group_id
5631: and p_effective_date between ctp.effective_start_date

Line 6026: (p_base_table_name => 'ben_ptip_f',

6022: p_argument => 'pgm_id',
6023: p_argument_value => p_pgm_id);
6024: --
6025: If (dt_api.rows_exist
6026: (p_base_table_name => 'ben_ptip_f',
6027: p_base_key_column => 'pgm_id',
6028: p_base_key_value => p_pgm_id,
6029: p_from_date => p_validation_start_date,
6030: p_to_date => p_validation_end_date)) Then

Line 6031: l_table_name := 'ben_ptip_f';

6027: p_base_key_column => 'pgm_id',
6028: p_base_key_value => p_pgm_id,
6029: p_from_date => p_validation_start_date,
6030: p_to_date => p_validation_end_date)) Then
6031: l_table_name := 'ben_ptip_f';
6032: Raise l_rows_exist;
6033: End If;
6034: If (dt_api.rows_exist
6035: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',