DBA Data[Home] [Help]

APPS.BEN_PRTT_RMT_APRVD_PYMT_API dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 74: ben_prtt_reimbmt_rqst_f prc

70: ,prc.incrd_from_dt
71: ,prc.incrd_to_dt
72: ,prc.exp_incurd_dt
73: from ben_pl_f pln ,
74: ben_prtt_reimbmt_rqst_f prc
75: where pln.pl_id = prc.pl_id
76: and prc.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
77: and p_effective_date
78: between prc.effective_start_date

Line 610: from ben_prtt_reimbmt_rqst_f prc

606: cursor c_old_prc is
607: select prc.submitter_person_id,
608: prc.pl_id,
609: prc.prtt_enrt_rslt_id
610: from ben_prtt_reimbmt_rqst_f prc
611: where prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
612: and p_effective_date between
613: prc.effective_start_date and
614: prc.effective_end_date;

Line 1049: from ben_prtt_reimbmt_rqst_f prc ,

1045: cursor c_old_prc is
1046: select prc.submitter_person_id
1047: ,prc.prtt_reimbmt_rqst_id
1048: ,prc.business_group_id
1049: from ben_prtt_reimbmt_rqst_f prc ,
1050: ben_prtt_rmt_aprvd_fr_pymt_f pyr
1051: where prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
1052: and prc.prtt_reimbmt_rqst_id = pyr.prtt_reimbmt_rqst_id
1053: and p_effective_date between