APPS.BEN_BENCLAUD_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 76: ben_benefit_actions b

72: l_all := substrb(fnd_message.get,1,80);
73: begin
74: select location_code into CP_LOCATION
75: from hr_locations a,
76: ben_benefit_actions b
77: where a.location_id = b.location_id
78: and b.request_id = P_CONCURRENT_REQUEST_ID;
79:
80: exception when no_data_found then

Line 86: ben_benefit_actions b

82: end;
83: begin
84: select meaning into CP_AUDIT_LOG
85: from hr_lookups a,
86: ben_benefit_actions b
87: where a.lookup_type = 'YES_NO'
88: and a.lookup_code = b.AUDIT_LOG_FLAG
89: and b.request_id = P_CONCURRENT_REQUEST_ID;
90:

Line 97: ben_benefit_actions b

93: end;
94: begin
95: select meaning into CP_CLOSE_ACTION_ITEMS_FLAG
96: from hr_lookups a,
97: ben_benefit_actions b
98: where a.lookup_type = 'YES_NO'
99: and a.lookup_code = b.close_uneai_flag
100: and b.request_id = P_CONCURRENT_REQUEST_ID;
101:

Line 107: from ben_benefit_actions b

103: null;
104: end;
105: begin
106: select b.uneai_effective_date into CP_ACTION_ITEM_EFFECTIVE_DATE
107: from ben_benefit_actions b
108: where b.request_id = P_CONCURRENT_REQUEST_ID;
109:
110: exception when no_data_found then
111: null;

Line 115: from ben_benefit_actions b

111: null;
112: end;
113: begin
114: select b.lf_evt_ocrd_dt into CP_ASSIGNED_LIFE_EVENT_DATE
115: from ben_benefit_actions b
116: where b.request_id = P_CONCURRENT_REQUEST_ID;
117:
118: exception when no_data_found then
119: null;

Line 123: from ben_benefit_actions bft, hr_lookups hl

119: null;
120: end;
121: begin
122: select hl.meaning into CP_CLOSE_MODE
123: from ben_benefit_actions bft, hr_lookups hl
124: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
125: and hl.lookup_type = 'BEN_BENCLENR_MD'
126: and bft.request_id = P_CONCURRENT_REQUEST_ID;
127: