APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on HR_API

Line 78: hr_api_transactions txn,

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

Line 79: hr_api_transaction_steps step ,

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

Line 80: hr_api_transaction_values vlv_choice

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

Line 121: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 2000: AND new_pep.effective_end_date = hr_api.g_eot

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

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

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