APPS.BEN_PRY_BUS dependencies on BEN_PRTT_RMT_APRVD_FR_PYMT_F

Line 29: , ben_prtt_rmt_aprvd_fr_pymt_f pry

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , ben_prtt_rmt_aprvd_fr_pymt_f pry
30: where pry.prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
31: and pbg.business_group_id = pry.business_group_id;
32: --
33: -- Declare local variables

Line 89: , ben_prtt_rmt_aprvd_fr_pymt_f pry

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , ben_prtt_rmt_aprvd_fr_pymt_f pry
90: where pry.prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
91: and pbg.business_group_id (+) = pry.business_group_id;
92: --
93: -- Declare local variables

Line 167: from ben_prtt_rmt_aprvd_fr_pymt_f pry

163: -- curent entry is not taken for calc tath is added in calling proc this helps while updating
164:
165: cursor c_pry is
166: select sum(nvl(pry.aprvd_fr_pymt_amt,0))
167: from ben_prtt_rmt_aprvd_fr_pymt_f pry
168: where pry.effective_end_date = hr_api.g_eot --future created entry to be taken for calc
169: and p_rec.prtt_reimbmt_rqst_id = pry.prtt_reimbmt_rqst_id
170: and (p_rec.prtt_rmt_aprvd_fr_pymt_id is null
171: or (p_rec.prtt_rmt_aprvd_fr_pymt_id <> pry.prtt_rmt_aprvd_fr_pymt_id ) )

Line 213: ben_prtt_rmt_aprvd_fr_pymt_f pry

209: p_person_id number,
210: p_popl_yr_perd number ) is
211: select sum(nvl(pry.APRVD_FR_PYMT_AMT,0))
212: from ben_prtt_reimbmt_rqst_f prc,
213: ben_prtt_rmt_aprvd_fr_pymt_f pry
214: where prc.submitter_person_id = p_person_id
215: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
216: and p_pl_id = prc.pl_id
217: and ((prc.popl_yr_perd_id_1 = p_popl_yr_perd and

Line 243: from ben_prtt_rmt_aprvd_fr_pymt_f pry

239: l_prc_overlap c_prc_overlap%rowtype;
240: --
241: cursor c_paid_amt (p_prtt_reimbmt_rqst_id number) is
242: select sum(nvl(pry.APRVD_FR_PYMT_AMT,0))
243: from ben_prtt_rmt_aprvd_fr_pymt_f pry
244: where pry.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id;
245: --
246: l_paid_amt number;
247: l_pl_info c_pl_info%rowtype ;