APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on HR_API

Line 76: hr_api_transactions txn,

72: cursor c_pending is
73: SELECT vlv_choice.number_value elig_per_elctbl_chc_id
74: from wf_item_activity_statuses process ,
75: wf_process_activities activity ,
76: hr_api_transactions txn,
77: hr_api_transaction_steps step ,
78: hr_api_transaction_values vlv_choice
79: WHERE activity.process_name = 'ROOT'
80: and activity.process_item_type = activity.activity_item_type

Line 77: hr_api_transaction_steps step ,

73: SELECT vlv_choice.number_value elig_per_elctbl_chc_id
74: from wf_item_activity_statuses process ,
75: wf_process_activities activity ,
76: hr_api_transactions txn,
77: hr_api_transaction_steps step ,
78: hr_api_transaction_values vlv_choice
79: WHERE activity.process_name = 'ROOT'
80: and activity.process_item_type = activity.activity_item_type
81: and activity.instance_id = process.process_activity

Line 78: hr_api_transaction_values vlv_choice

74: from wf_item_activity_statuses process ,
75: wf_process_activities activity ,
76: hr_api_transactions txn,
77: hr_api_transaction_steps step ,
78: hr_api_transaction_values vlv_choice
79: WHERE activity.process_name = 'ROOT'
80: and activity.process_item_type = activity.activity_item_type
81: and activity.instance_id = process.process_activity
82: and process.activity_status = 'ACTIVE'

Line 119: and pen.effective_end_date = hr_api.g_eot

115: and pen.business_group_id = epe.business_group_id
116: and pen.sspndd_flag = 'Y'
117: and nvl(epe.in_pndg_wkflow_flag,'N') = 'N'
118: and pen.prtt_enrt_rslt_stat_cd IS NULL
119: and pen.effective_end_date = hr_api.g_eot
120: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
121: /* need to worry about the following conditions
122: and p_effective_date
123: between enrt_cvg_strt_dt

Line 120: and pen.enrt_cvg_thru_dt = hr_api.g_eot;

116: and pen.sspndd_flag = 'Y'
117: and nvl(epe.in_pndg_wkflow_flag,'N') = 'N'
118: and pen.prtt_enrt_rslt_stat_cd IS NULL
119: and pen.effective_end_date = hr_api.g_eot
120: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
121: /* need to worry about the following conditions
122: and p_effective_date
123: between enrt_cvg_strt_dt
124: and enrt_cvg_thru_dt

Line 1997: AND new_pep.effective_end_date = hr_api.g_eot

1993: )
1994: AND old_pep.effective_start_date > p_effective_date
1995: AND old_pep.effective_start_date > new_pep.effective_start_date
1996: AND new_pep.effective_start_date = p_effective_date
1997: AND new_pep.effective_end_date = hr_api.g_eot
1998: GROUP BY new_pep.elig_per_id, new_pep.object_version_number;
1999:
2000: /**
2001: Get the new child epos of new peps which has corresponding future pep

Line 2016: -- AND new_epo.effective_end_date = hr_api.g_eot;

2012: WHERE new_epo.elig_per_id = v_elig_per_id
2013: -- bug 5658405
2014: -- AND new_epo.per_in_ler_id = p_per_in_ler_id
2015: -- AND new_epo.effective_start_date = p_effective_date
2016: -- AND new_epo.effective_end_date = hr_api.g_eot;
2017: AND v_end_date BETWEEN new_epo.effective_start_date
2018: AND new_epo.effective_end_date;
2019:
2020: -- added bug 5658405