[Home] [Help]
1661: ppe.std_prem_uom,
1662: ppe.std_prem_val,
1663: ppe.actl_prem_id,
1664: ppe.object_version_number
1665: from ben_prtt_prem_f ppe
1666: -- ben_per_in_ler pil
1667: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1668: and ppe.actl_prem_id = p_actl_prem_id
1669: and p_effective_date between
1680: ppe.std_prem_uom,
1681: ppe.std_prem_val,
1682: ppe.actl_prem_id,
1683: ppe.object_version_number
1684: from ben_prtt_prem_f ppe
1685: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1686: and ppe.actl_prem_id = p_actl_prem_id
1687: and /*p_effective_date*/ p_ppe_dt_to_use between
1688: ppe.effective_start_date and ppe.effective_end_date;
2078: -- Find the valid datetrack modes.
2079: --
2080: dt_api.find_dt_upd_modes
2081: (p_effective_date => l_ppe_dt_to_use,
2082: p_base_table_name => 'BEN_PRTT_PREM_F',
2083: p_base_key_column => 'prtt_prem_id',
2084: p_base_key_value => l_ppe.prtt_prem_id,
2085: p_correction => lb_correction,
2086: p_update => lb_update,
3056: ppe.std_prem_val,
3057: ppe.actl_prem_id,
3058: ppe.object_version_number,
3059: ppe.effective_start_date
3060: from ben_prtt_prem_f ppe,
3061: ben_per_in_ler pil
3062: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3063: and ppe.actl_prem_id = p_actl_prem_id
3064: /*
3080: cursor c_ppe1 (p_prtt_enrt_rslt_id in number,
3081: p_actl_prem_id in number,
3082: p_ppe_dt_to_use in date) is
3083: select ppe.*
3084: from ben_prtt_prem_f ppe,
3085: ben_per_in_ler pil
3086: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3087: and ppe.actl_prem_id = p_actl_prem_id
3088: and p_ppe_dt_to_use <= ppe.effective_start_date
3906: -- Find the valid datetrack modes.
3907: --
3908: dt_api.find_dt_upd_modes
3909: (p_effective_date => p_effective_date,
3910: p_base_table_name => 'BEN_PRTT_PREM_F',
3911: p_base_key_column => 'prtt_prem_id',
3912: p_base_key_value => l_ppe.prtt_prem_id,
3913: p_correction => l_correction,
3914: p_update => l_update,
4021: LCR_ATTRIBUTE4,
4022: LCR_ATTRIBUTE5
4023: )
4024: values (
4025: 'BEN_PRTT_PREM_F_CORR',
4026: l_ppe1.PPE_ATTRIBUTE6,
4027: l_ppe1.PPE_ATTRIBUTE7,
4028: l_ppe1.PPE_ATTRIBUTE8,
4029: l_ppe1.PPE_ATTRIBUTE9,
4104: -- Find the valid datetrack modes.
4105: --
4106: dt_api.find_dt_upd_modes
4107: (p_effective_date => l_ppe_dt_to_use,
4108: p_base_table_name => 'BEN_PRTT_PREM_F',
4109: p_base_key_column => 'prtt_prem_id',
4110: p_base_key_value => l_ppe.prtt_prem_id,
4111: p_correction => l_correction,
4112: p_update => l_update,
6380: ppe.object_version_number,
6381: ppe.effective_start_date,
6382: ppe.effective_end_date,
6383: ppe.actl_prem_id
6384: from ben_prtt_prem_f ppe,
6385: ben_per_in_ler pil
6386: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6387: and pil.per_in_ler_id=ppe.per_in_ler_id
6388: and pil.business_group_id=ppe.business_group_id
6394: ppe.object_version_number,
6395: ppe.effective_start_date,
6396: ppe.effective_end_date,
6397: ppe.actl_prem_id
6398: from ben_prtt_prem_f ppe,
6399: ben_per_in_ler pil
6400: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6401: and pil.per_in_ler_id=ppe.per_in_ler_id
6402: and pil.business_group_id=ppe.business_group_id
6410: ppe1.object_version_number,
6411: ppe1.effective_start_date,
6412: ppe1.effective_end_date,
6413: ppe1.actl_prem_id
6414: from ben_prtt_prem_f ppe1,
6415: ben_per_in_ler pil
6416: where ppe1.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6417: and pil.per_in_ler_id=ppe1.per_in_ler_id
6418: and pil.business_group_id=ppe1.business_group_id
6419: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
6420: and ppe1.effective_start_date > p_ppe_dt_to_use
6421: and not exists
6422: (select 1
6423: from ben_prtt_prem_f ppe2,
6424: ben_per_in_ler pil
6425: where ppe2.prtt_prem_id = ppe1.prtt_prem_id
6426: and ppe2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6427: and pil.per_in_ler_id=ppe2.per_in_ler_id