APPS.BEN_PRTT_CLM_GD_R_SVC_TYP_API dependencies on BEN_PRTT_REIMBMT_RQST_F
Line 147: from ben_prtt_reimbmt_rqst_f prc ,
143: l_dummy_var varchar2(1) ;
144: ---Cursor for formula
145: cursor c_asg is
146: select prc.pl_id,asg.assignment_id 147: from ben_prtt_reimbmt_rqst_f prc , 148: per_all_assignments_f asg
149: where prc.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
150: and p_effective_date between
151: prc.effective_start_date and prc.effective_end_date