APPS.BEN_BENBOSUM_XMLP_PKG dependencies on BEN_REPORTING

Line 112: from ben_reporting rpt,

108: l_val number;
109: begin
110: select count(distinct rpt.person_id)
111: into CP_PEOPLE_LF_EVT_BO
112: from ben_reporting rpt,
113: ben_benefit_actions ba
114: where ba.request_id=P_CONCURRENT_REQUEST_ID and
115: ba.benefit_action_id=rpt.benefit_action_id and
116: rpt.rep_typ_cd='LFBO';

Line 120: from ben_reporting rpt,

116: rpt.rep_typ_cd='LFBO';
117:
118: select count(rpt.person_id)
119: into CP_LF_EVT_BO
120: from ben_reporting rpt,
121: ben_benefit_actions ba
122: where ba.request_id=P_CONCURRENT_REQUEST_ID and
123: ba.benefit_action_id=rpt.benefit_action_id and
124: rpt.rep_typ_cd='LFBO';

Line 128: from ben_reporting rpt,

124: rpt.rep_typ_cd='LFBO';
125:
126: select count(rpt.person_id)
127: into CP_LF_EVT_BO_CLS
128: from ben_reporting rpt,
129: ben_benefit_actions ba
130: where ba.request_id=P_CONCURRENT_REQUEST_ID and
131: ba.benefit_action_id=rpt.benefit_action_id and
132: rpt.rep_typ_cd='LFBO' and

Line 137: from ben_reporting rpt,

133: rpt.text like 'PROCD_';
134:
135: select count(rpt.person_id)
136: into CP_LF_EVT_BO_IP_WE
137: from ben_reporting rpt,
138: ben_benefit_actions ba
139: where ba.request_id=P_CONCURRENT_REQUEST_ID and
140: ba.benefit_action_id=rpt.benefit_action_id and
141: rpt.rep_typ_cd='LFBO' and

Line 146: from ben_reporting rpt,

142: rpt.text = 'STRTDY';
143:
144: select count(rpt.person_id)
145: into CP_LF_EVT_BO_IP_WOE
146: from ben_reporting rpt,
147: ben_benefit_actions ba
148: where ba.request_id=P_CONCURRENT_REQUEST_ID and
149: ba.benefit_action_id=rpt.benefit_action_id and
150: rpt.rep_typ_cd='LFBO' and