APPS.BEN_BENDFAUD_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 84: ben_benefit_actions b

80: l_all := substrb(fnd_message.get,1,80);
81: begin
82: select location_code into CP_LOCATION
83: from hr_locations a,
84: ben_benefit_actions b
85: where a.location_id = b.location_id
86: and b.request_id = P_CONCURRENT_REQUEST_ID;
87:
88: exception when no_data_found then

Line 94: ben_benefit_actions b

90: end;
91: begin
92: select meaning into CP_AUDIT_LOG
93: from hr_lookups a,
94: ben_benefit_actions b
95: where a.lookup_type = 'YES_NO'
96: and a.lookup_code = b.AUDIT_LOG_FLAG
97: and b.request_id = P_CONCURRENT_REQUEST_ID;
98:

Line 105: ben_benefit_actions b

101: end;
102: begin
103: select name into CP_BENEFIT_GROUP
104: from ben_benfts_grp a,
105: ben_benefit_actions b
106: where a.benfts_grp_id = b.benfts_grp_id
107: and b.request_id = P_CONCURRENT_REQUEST_ID;
108:
109: exception when no_data_found then