APPS.BEN_BENBOSUM_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 66: ben_benefit_actions b

62: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
63: l_all := substrb(fnd_message.get,1,80);
64: select name into CP_PERSON_BNFT_GRP
65: from ben_benfts_grp a,
66: ben_benefit_actions b
67: where a.benfts_grp_id = b.benfts_grp_id
68: and b.request_id = P_CONCURRENT_REQUEST_ID;
69:
70: exception when no_data_found then

Line 77: ben_benefit_actions b

73:
74: begin
75: select location_code into CP_LOCATION
76: from hr_locations a,
77: ben_benefit_actions b
78: where a.location_id = b.location_id
79: and b.request_id = P_CONCURRENT_REQUEST_ID;
80:
81: exception when no_data_found then

Line 87: from ben_benefit_actions

83: end;
84:
85: begin
86: select date_from, uneai_effective_date into CP_FROM_OCRD_DT, CP_TO_OCRD_DT
87: from ben_benefit_actions
88: where request_id = P_CONCURRENT_REQUEST_ID;
89:
90: exception when no_data_found then
91: null;

Line 95: from ben_benefit_actions bft, hr_lookups hl

91: null;
92: end;
93: begin
94: select hl.meaning into CP_RESULTING_STATUS
95: from ben_benefit_actions bft, hr_lookups hl
96: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
97: and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
98: and bft.request_id = P_CONCURRENT_REQUEST_ID;
99:

Line 113: ben_benefit_actions ba

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';
117:

Line 121: ben_benefit_actions ba

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';
125:

Line 129: ben_benefit_actions ba

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
133: rpt.text like 'PROCD_';

Line 138: ben_benefit_actions ba

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
142: rpt.text = 'STRTDY';

Line 147: ben_benefit_actions ba

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
151: rpt.text = 'STRTDN';