DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 260: BEN_PRTT_REIMBMT_RQST_F to show custom message

256: 30-May-02 ikasire 115.70 Bug 2386000 Added p_called_from parameter to
257: delete_elig_cvrd_dpnt calll
258: 22-Aug-02 ikasire 115.71 Bug 2526994 g_backout_flag needs to be reset
259: 23-Aug-02 hnarayan 115.72 - Bug 2518955 - modified delete_routine for
260: BEN_PRTT_REIMBMT_RQST_F to show custom message
261: 12-sep-02 vsethi 115.73 - Bug 2552295 to ben_plan_beneficiary_api passing
262: p_multi_row_actn as False.
263: 24-Sep-02 kmahendr 115.74 -Bug2592783 - per_in_stat_cd added to cursor
264: c_bpl_max_esd_of_past_pil.

Line 1289: -- BEN_PRTT_REIMBMT_RQST_F

1285: -- BEN_PL_BNF_F (PBN) (join to pil to check status)
1286: -- BEN_PRTT_ENRT_ACTN_F (PEA) (join to pil to check status)
1287: -- BEN_BNFT_PRVDD_LDGR_F (BPL)(join to pil to check status)
1288: -- BEN_PRTT_RT_VAL (PRV)
1289: -- BEN_PRTT_REIMBMT_RQST_F
1290: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1291: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)
1292: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1293: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)

Line 3378: from ben_prtt_reimbmt_rqst_f prc

3374: select prc.PRTT_REIMBMT_RQST_ID
3375: ,prc.OBJECT_VERSION_NUMBER
3376: ,prc.effective_start_date
3377: ,pil.person_id
3378: from ben_prtt_reimbmt_rqst_f prc
3379: ,ben_prtt_rt_val prv
3380: ,ben_per_in_ler pil
3381: where prv.per_in_ler_id = p_per_in_ler_id
3382: and prv.PRTT_REIMBMT_RQST_id = prc.PRTT_REIMBMT_RQST_id