APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on HRI_EQ_BEN_ELIGENRL_EVTS

Line 84: g_eligenrl_evts_eq_table VARCHAR2(50) := 'HRI_EQ_BEN_ELIGENRL_EVTS';

80: g_eligenrl_evnt_table VARCHAR2(50) := 'HRI_MB_BEN_ELIGENRL_EVNT_CT';
81: g_elctn_evnt_table VARCHAR2(50) := 'HRI_MB_BEN_ELCTN_EVNT_CT';
82: --
83: g_elctn_evts_eq_table VARCHAR2(50) := 'HRI_EQ_BEN_ELCTN_EVTS';
84: g_eligenrl_evts_eq_table VARCHAR2(50) := 'HRI_EQ_BEN_ELIGENRL_EVTS';
85:
86: -- -----------------------------------------------------------------------------
87: -- Inserts row into concurrent program log
88: -- -----------------------------------------------------------------------------

Line 272: p_sqlstr := p_sqlstr || ' FROM hri_eq_ben_eligenrl_evts penq ';

268: -- Return the sql query to fetch PERSON_ID ranges
269: --
270: p_sqlstr := ' ';
271: p_sqlstr := p_sqlstr || ' SELECT penq.person_id object_id ';
272: p_sqlstr := p_sqlstr || ' FROM hri_eq_ben_eligenrl_evts penq ';
273: p_sqlstr := p_sqlstr || ' UNION '; -- Removes Duplicates
274: -- 4501649 Election Events to be considered for incremental refresh.
275: p_sqlstr := p_sqlstr || ' SELECT pelq.person_id object_id ';
276: p_sqlstr := p_sqlstr || ' FROM hri_eq_ben_elctn_evts pelq ';

Line 814: FROM hri_eq_ben_eligenrl_evts penq,

810: SELECT PRTTQ.eee_end_dt, penc.rowid row_id
811: FROM (SELECT NVL(MIN(penq.event_date-1),hr_api.g_eot) eee_end_dt,
812: copd.compobj_sk_pk,
813: penq.lf_evt_ocrd_dt
814: FROM hri_eq_ben_eligenrl_evts penq,
815: hri_cs_compobj_ct copd
816: WHERE penq.per_in_ler_id = p_per_in_ler_id
817: AND penq.pgm_id = copd.pgm_id
818: AND copd.oipl_id = NVL(penq.oipl_id, -1)

Line 851: FROM hri_eq_ben_eligenrl_evts penq,

847: WHERE (penc.compobj_sk_pk, penc.asnd_lf_evt_dt, penc.person_id)
848: IN (SELECT copd.compobj_sk_pk
849: ,penq.lf_evt_ocrd_dt
850: ,penq.person_id
851: FROM hri_eq_ben_eligenrl_evts penq,
852: hri_cs_compobj_ct copd
853: WHERE penq.per_in_ler_id = p_per_in_ler_id
854: AND penq.event_cd IN ('ZAP','DE-ENRD')
855: AND penq.pgm_id = copd.pgm_id

Line 907: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq,

903: AND (opt.invk_wv_opt_flag = 'Y'
904: OR (opt.opt_id IS NULL AND pln.invk_dcln_prtn_pl_flag = 'Y')) )
905: THEN 1
906: ELSE 0 END ) waive_dflt_ind
907: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq,
908: hri_cs_time_benrl_prd_ct enpd,
909: hri_cs_compobj_ct copd,
910: ben_opt_f opt,
911: ben_pl_f pln

Line 925: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq1

921: AND copd.oipl_id = NVL(penq.oipl_id, -1)
922: AND copd.pl_id = penq.pl_id
923: AND NOT EXISTS
924: (SELECT null -- Picks up only the latest Event from queue.
925: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq1
926: WHERE penq1.per_in_ler_id = p_per_in_ler_id
927: AND NVL(penq1.oipl_id,-1) = NVL(penq.oipl_id,-1)
928: AND penq1.pl_id = penq.pl_id
929: AND penq1.pgm_id = penq.pgm_id

Line 1403: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq

1399: ,p_end_object_id IN NUMBER) IS
1400:
1401: CURSOR c_per_in_evt IS
1402: SELECT DISTINCT penq.person_id, penq.per_in_ler_id, lf_evt_ocrd_dt
1403: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq
1404: WHERE penq.person_id BETWEEN p_start_object_id AND p_end_object_id
1405: ORDER BY penq.person_id, penq.per_in_ler_id;
1406:
1407: CURSOR c_elcn_evt IS