APPS.BEN_BENCLSUM_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 91: ben_benefit_actions b

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

Line 101: ben_benefit_actions b

97: end;
98: begin
99: select meaning into CP_AUDIT_LOG_FLAG
100: from hr_lookups a,
101: ben_benefit_actions b
102: where a.lookup_type = 'YES_NO'
103: and a.lookup_code = b.AUDIT_LOG_FLAG
104: and b.request_id = P_CONCURRENT_REQUEST_ID;
105:

Line 112: ben_benefit_actions b

108: end;
109: begin
110: select meaning into CP_CLOSE_ACTION_ITEMS_FLAG
111: from hr_lookups a,
112: ben_benefit_actions b
113: where a.lookup_type = 'YES_NO'
114: and a.lookup_code = b.close_uneai_flag
115: and b.request_id = P_CONCURRENT_REQUEST_ID;
116:

Line 122: from ben_benefit_actions b

118: null;
119: end;
120: begin
121: select b.uneai_effective_date into CP_ACTION_ITEM_EFFECTIVE_DATE
122: from ben_benefit_actions b
123: where b.request_id = P_CONCURRENT_REQUEST_ID;
124:
125: exception when no_data_found then
126: null;

Line 130: from ben_benefit_actions b

126: null;
127: end;
128: begin
129: select b.lf_evt_ocrd_dt into CP_ASSIGNED_LIFE_EVENT_DATE
130: from ben_benefit_actions b
131: where b.request_id = P_CONCURRENT_REQUEST_ID;
132:
133: exception when no_data_found then
134: null;

Line 138: from ben_benefit_actions bft, hr_lookups hl

134: null;
135: end;
136: begin
137: select hl.meaning into CP_CLOSE_MODE
138: from ben_benefit_actions bft, hr_lookups hl
139: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
140: and hl.lookup_type = 'BEN_BENCLENR_MD'
141: and bft.request_id = P_CONCURRENT_REQUEST_ID;
142: