DBA Data[Home] [Help]

APPS.BEN_BENACTIV_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 81: ben_benefit_actions bft

77: l_all := substrb(fnd_message.get,1,80);
78: begin
79: select loc.location_code into CP_LOCATION
80: from hr_locations loc,
81: ben_benefit_actions bft
82: where bft.request_id = P_CONCURRENT_REQUEST_ID
83: and bft.location_id = loc.location_id;
84:
85: exception

Line 93: ben_benefit_actions bft

89:
90: begin
91: select bng.name into CP_PERSON_BNFT_GRP
92: from ben_benfts_grp bng,
93: ben_benefit_actions bft
94: where bft.request_id = P_CONCURRENT_REQUEST_ID
95: and bft.benfts_grp_id = bng.benfts_grp_id;
96:
97: exception

Line 104: from ben_benefit_actions bft

100: end;
101:
102: begin
103: select decode(audit_log_flag, 'Y', 'Yes', 'N', 'No') into CP_AUDIT_FLAG
104: from ben_benefit_actions bft
105: where bft.request_id = P_CONCURRENT_REQUEST_ID;
106:
107:
108: exception

Line 115: from ben_benefit_actions bft

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

Line 261: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp

257:
258: function AfterPForm return boolean is
259: CURSOR c_conc_pgm_name (cv_request_id number) is
260: SELECT fcp.concurrent_program_name
261: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp
262: WHERE bft.program_id = fcp.concurrent_program_id
263: AND bft.request_id = cv_request_id;
264: l_source_program varchar2(30);
265: begin