eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BENPRSUM_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 96: ,ben_benefit_actions bft

92: begin
93: Select count(distinct rep.person_id) prcurmop
94: into CP_PRCURMOP
95: from ben_reporting rep
96: ,ben_benefit_actions bft
97: where bft.benefit_action_id = rep.benefit_action_id
98: and bft.request_id = P_CONCURRENT_REQUEST_ID
99: and rep.rep_typ_cd in ('PRCURMOP', 'PRPPOIPL')
100: and not exists (select distinct rep.person_id

Line 102: ,ben_benefit_actions bft

98: and bft.request_id = P_CONCURRENT_REQUEST_ID
99: and rep.rep_typ_cd in ('PRCURMOP', 'PRPPOIPL')
100: and not exists (select distinct rep.person_id
101: from ben_reporting rep
102: ,ben_benefit_actions bft
103: where bft.benefit_action_id = rep.benefit_action_id
104: and bft.request_id = P_CONCURRENT_REQUEST_ID
105: and rep.rep_typ_cd in ('PRRETROP', 'PRCREDIT')) ;
106:

Line 110: ,ben_benefit_actions bft

106:
107: Select count(distinct rep.person_id) prcredit
108: into CP_PRCREDIT
109: from ben_reporting rep
110: ,ben_benefit_actions bft
111: where bft.benefit_action_id = rep.benefit_action_id
112: and bft.request_id = P_CONCURRENT_REQUEST_ID
113: and rep.rep_typ_cd = ('PRCREDIT')
114: and not exists (select distinct rep.person_id

Line 116: ,ben_benefit_actions bft

112: and bft.request_id = P_CONCURRENT_REQUEST_ID
113: and rep.rep_typ_cd = ('PRCREDIT')
114: and not exists (select distinct rep.person_id
115: from ben_reporting rep
116: ,ben_benefit_actions bft
117: where bft.benefit_action_id = rep.benefit_action_id
118: and bft.request_id = P_CONCURRENT_REQUEST_ID
119: and rep.rep_typ_cd in ('PRCURMOP', 'PRRETROP', 'PRPPOIPL')) ;
120:

Line 124: ,ben_benefit_actions bft

120:
121: Select count(distinct rep.person_id) prretrop
122: into CP_PRRETROP
123: from ben_reporting rep
124: ,ben_benefit_actions bft
125: where bft.benefit_action_id = rep.benefit_action_id
126: and bft.request_id = P_CONCURRENT_REQUEST_ID
127: and rep.rep_typ_cd = ('PRRETROP')
128: and not exists (select distinct rep.person_id

Line 130: ,ben_benefit_actions bft

126: and bft.request_id = P_CONCURRENT_REQUEST_ID
127: and rep.rep_typ_cd = ('PRRETROP')
128: and not exists (select distinct rep.person_id
129: from ben_reporting rep
130: ,ben_benefit_actions bft
131: where bft.benefit_action_id = rep.benefit_action_id
132: and bft.request_id = P_CONCURRENT_REQUEST_ID
133: and rep.rep_typ_cd in ('PRCURMOP', 'PRCREDIT', 'PRPPOIPL')) ;
134:

Line 139: ,ben_benefit_actions bft

135:
136: Select count(distinct rep.person_id) prtotal
137: into CP_PRTOTAL
138: from ben_reporting rep
139: ,ben_benefit_actions bft
140: where bft.benefit_action_id = rep.benefit_action_id
141: and bft.request_id = P_CONCURRENT_REQUEST_ID
142: and rep.rep_typ_cd IN ('PRCREDIT', 'PRCURMOP', 'PRRETROP', 'PRPPOIPL') ;
143: