APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_PRTT_PREM_F

Line 712: from ben_prtt_prem_f ppe,

708: ppe.object_version_number,
709: ppe.effective_start_date,
710: ppe.effective_end_date,
711: ppe.actl_prem_id
712: from ben_prtt_prem_f ppe,
713: ben_per_in_ler pil
714: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
715: and pil.per_in_ler_id=ppe.per_in_ler_id
716: and pil.business_group_id=ppe.business_group_id

Line 725: from ben_prtt_prem_f ppe1,

721: ppe1.object_version_number,
722: ppe1.effective_start_date,
723: ppe1.effective_end_date,
724: ppe1.actl_prem_id
725: from ben_prtt_prem_f ppe1,
726: ben_per_in_ler pil
727: where ppe1.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
728: and pil.per_in_ler_id=ppe1.per_in_ler_id
729: and pil.business_group_id=ppe1.business_group_id

Line 734: from ben_prtt_prem_f ppe2,

730: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
731: and ppe1.effective_start_date > p_ppe_dt_to_use
732: and not exists
733: (select 1
734: from ben_prtt_prem_f ppe2,
735: ben_per_in_ler pil
736: where ppe2.prtt_prem_id = ppe1.prtt_prem_id
737: and ppe2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
738: and pil.per_in_ler_id=ppe2.per_in_ler_id

Line 938: from ben_prtt_prem_f ppe,

934: ppe.effective_start_date,
935: ppe.effective_end_date,
936: ppe.actl_prem_id,
937: ppe.business_group_id
938: from ben_prtt_prem_f ppe,
939: ben_per_in_ler pil
940: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
941: and pil.per_in_ler_id=ppe.per_in_ler_id
942: and pil.business_group_id=ppe.business_group_id

Line 953: from ben_prtt_prem_f ppe1,

949: ppe1.effective_start_date,
950: ppe1.effective_end_date,
951: ppe1.actl_prem_id,
952: ppe1.business_group_id
953: from ben_prtt_prem_f ppe1,
954: ben_per_in_ler pil
955: where ppe1.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
956: and pil.per_in_ler_id=ppe1.per_in_ler_id
957: and pil.business_group_id=ppe1.business_group_id

Line 963: from ben_prtt_prem_f ppe2,

959: and ppe1.effective_start_date > p_ppe_dt_to_use
960: and ppe1.effective_end_date <> hr_api.g_eot
961: and not exists
962: (select 1
963: from ben_prtt_prem_f ppe2,
964: ben_per_in_ler pil
965: where ppe2.prtt_prem_id = ppe1.prtt_prem_id
966: and ppe2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
967: and pil.per_in_ler_id=ppe2.per_in_ler_id

Line 1129: from ben_prtt_prem_f ppe,

1125: ppe.std_prem_val,
1126: ppe.actl_prem_id,
1127: ppe.object_version_number,
1128: ppe.effective_start_date
1129: from ben_prtt_prem_f ppe,
1130: ben_per_in_ler pil
1131: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1132: and ppe.actl_prem_id = p_actl_prem_id
1133: and p_ppe_dt_to_use between

Line 1251: p_base_table_name => 'BEN_PRTT_PREM_F',

1247: -- Find the valid datetrack modes.
1248: --
1249: dt_api.find_dt_upd_modes
1250: (p_effective_date => l_ppe_dt_to_use,
1251: p_base_table_name => 'BEN_PRTT_PREM_F',
1252: p_base_key_column => 'prtt_prem_id',
1253: p_base_key_value => l_ppe.prtt_prem_id,
1254: p_correction => l_correction,
1255: p_update => l_update,