APPS.BEN_BENERPER_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 107: from ben_benefit_actions

103: CP_STATUS := l_status;
104: CP_START_DATE := l_date_From;
105: begin
106: select date_from, uneai_effective_date into CP_FROM_OCRD_DT, CP_TO_OCRD_DT
107: from ben_benefit_actions
108: where request_id = P_CONCURRENT_REQUEST_ID;
109:
110: exception when no_data_found then
111: null;

Line 115: from ben_benefit_actions bft, hr_lookups hl

111: null;
112: end;
113: begin
114: select hl.meaning into CP_BCKT_STAT_CD
115: from ben_benefit_actions bft, hr_lookups hl
116: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
117: and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
118: and bft.request_id = P_CONCURRENT_REQUEST_ID;
119:

Line 323: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp

319:
320: function AfterPForm return boolean is
321: CURSOR c_conc_pgm_name (cv_request_id number) is
322: SELECT fcp.concurrent_program_name
323: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp
324: WHERE bft.program_id = fcp.concurrent_program_id
325: AND bft.request_id = cv_request_id;
326: l_source_program varchar2(30);
327: begin