APPS.BEN_BENERRTY_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 90: ben_benefit_actions bft

86: CP_STATUS := l_status;
87: begin
88: select loc.location_code into CP_LOCATION
89: from hr_locations loc,
90: ben_benefit_actions bft
91: where bft.request_id = p_concurrent_request_id
92: and bft.location_id = loc.location_id;
93:
94: exception

Line 102: ben_benefit_actions bft

98:
99: begin
100: select bng.name into CP_PERSON_BNFT_GRP
101: from ben_benfts_grp bng,
102: ben_benefit_actions bft
103: where bft.request_id = p_concurrent_request_id
104: and bft.benfts_grp_id = bng.benfts_grp_id;
105:
106: exception

Line 113: from ben_benefit_actions bft

109: end;
110:
111: begin
112: select decode(audit_log_flag, 'Y', 'Yes', 'N', 'No') into CP_AUDIT_FLAG
113: from ben_benefit_actions bft
114: where bft.request_id = p_concurrent_request_id;
115:
116:
117: exception

Line 124: from ben_benefit_actions bft

120: end;
121:
122: begin
123: select decode(lmt_prpnip_by_org_flag, 'Y', 'Yes', 'N', 'No') into CP_LMT_BY_ORG_FLAG
124: from ben_benefit_actions bft
125: where bft.request_id = p_concurrent_request_id;
126:
127:
128: exception

Line 192: from ben_benefit_actions

188:
189: p_date_mask := fnd_profile.value('ICX_DATE_FORMAT_MASK');
190: select benefit_action_id, process_date
191: into p_benefit_action_id, l_date
192: from ben_benefit_actions
193: where request_id = p_concurrent_request_id ;
194:
195: p_process_date := to_char(l_date, P_DATE_MASK) ;
196: return (TRUE);