[Home] [Help]
1588: ppe.std_prem_uom,
1589: ppe.std_prem_val,
1590: ppe.actl_prem_id,
1591: ppe.object_version_number
1592: from ben_prtt_prem_f ppe
1593: -- ben_per_in_ler pil
1594: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1595: and ppe.actl_prem_id = p_actl_prem_id
1596: and p_effective_date between
1607: ppe.std_prem_uom,
1608: ppe.std_prem_val,
1609: ppe.actl_prem_id,
1610: ppe.object_version_number
1611: from ben_prtt_prem_f ppe
1612: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1613: and ppe.actl_prem_id = p_actl_prem_id
1614: and /*p_effective_date*/ p_ppe_dt_to_use between
1615: ppe.effective_start_date and ppe.effective_end_date;
1996: -- Find the valid datetrack modes.
1997: --
1998: dt_api.find_dt_upd_modes
1999: (p_effective_date => l_ppe_dt_to_use,
2000: p_base_table_name => 'BEN_PRTT_PREM_F',
2001: p_base_key_column => 'prtt_prem_id',
2002: p_base_key_value => l_ppe.prtt_prem_id,
2003: p_correction => lb_correction,
2004: p_update => lb_update,
2946: ppe.std_prem_val,
2947: ppe.actl_prem_id,
2948: ppe.object_version_number,
2949: ppe.effective_start_date
2950: from ben_prtt_prem_f ppe,
2951: ben_per_in_ler pil
2952: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2953: and ppe.actl_prem_id = p_actl_prem_id
2954: /*
2970: cursor c_ppe1 (p_prtt_enrt_rslt_id in number,
2971: p_actl_prem_id in number,
2972: p_ppe_dt_to_use in date) is
2973: select ppe.*
2974: from ben_prtt_prem_f ppe,
2975: ben_per_in_ler pil
2976: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2977: and ppe.actl_prem_id = p_actl_prem_id
2978: and p_ppe_dt_to_use <= ppe.effective_start_date
3711: -- Find the valid datetrack modes.
3712: --
3713: dt_api.find_dt_upd_modes
3714: (p_effective_date => p_effective_date,
3715: p_base_table_name => 'BEN_PRTT_PREM_F',
3716: p_base_key_column => 'prtt_prem_id',
3717: p_base_key_value => l_ppe.prtt_prem_id,
3718: p_correction => l_correction,
3719: p_update => l_update,
3826: LCR_ATTRIBUTE4,
3827: LCR_ATTRIBUTE5
3828: )
3829: values (
3830: 'BEN_PRTT_PREM_F_CORR',
3831: l_ppe1.PPE_ATTRIBUTE6,
3832: l_ppe1.PPE_ATTRIBUTE7,
3833: l_ppe1.PPE_ATTRIBUTE8,
3834: l_ppe1.PPE_ATTRIBUTE9,
3909: -- Find the valid datetrack modes.
3910: --
3911: dt_api.find_dt_upd_modes
3912: (p_effective_date => l_ppe_dt_to_use,
3913: p_base_table_name => 'BEN_PRTT_PREM_F',
3914: p_base_key_column => 'prtt_prem_id',
3915: p_base_key_value => l_ppe.prtt_prem_id,
3916: p_correction => l_correction,
3917: p_update => l_update,
6091: ppe.object_version_number,
6092: ppe.effective_start_date,
6093: ppe.effective_end_date,
6094: ppe.actl_prem_id
6095: from ben_prtt_prem_f ppe,
6096: ben_per_in_ler pil
6097: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6098: and pil.per_in_ler_id=ppe.per_in_ler_id
6099: and pil.business_group_id=ppe.business_group_id
6105: ppe.object_version_number,
6106: ppe.effective_start_date,
6107: ppe.effective_end_date,
6108: ppe.actl_prem_id
6109: from ben_prtt_prem_f ppe,
6110: ben_per_in_ler pil
6111: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6112: and pil.per_in_ler_id=ppe.per_in_ler_id
6113: and pil.business_group_id=ppe.business_group_id
6121: ppe1.object_version_number,
6122: ppe1.effective_start_date,
6123: ppe1.effective_end_date,
6124: ppe1.actl_prem_id
6125: from ben_prtt_prem_f ppe1,
6126: ben_per_in_ler pil
6127: where ppe1.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6128: and pil.per_in_ler_id=ppe1.per_in_ler_id
6129: and pil.business_group_id=ppe1.business_group_id
6130: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
6131: and ppe1.effective_start_date > p_ppe_dt_to_use
6132: and not exists
6133: (select 1
6134: from ben_prtt_prem_f ppe2,
6135: ben_per_in_ler pil
6136: where ppe2.prtt_prem_id = ppe1.prtt_prem_id
6137: and ppe2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6138: and pil.per_in_ler_id=ppe2.per_in_ler_id