APPS.BEN_BENGELOG_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 91: ben_benefit_actions bft

87: l_all := substrb(fnd_message.get,1,80);
88: begin
89: select loc.location_code into CP_LOCATION
90: from hr_locations loc,
91: ben_benefit_actions bft
92: where bft.request_id = P_CONCURRENT_REQUEST_ID
93: and bft.location_id = loc.location_id;
94:
95: exception

Line 103: ben_benefit_actions bft

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

Line 114: from ben_benefit_actions bft

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

Line 125: from ben_benefit_actions bft

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

Line 190: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp

186: function AfterPForm return boolean is
187:
188: CURSOR c_conc_pgm_name (cv_request_id number) is
189: SELECT fcp.concurrent_program_name
190: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp
191: WHERE bft.program_id = fcp.concurrent_program_id
192: AND bft.request_id = cv_request_id;
193: l_source_program varchar2(30);
194: begin