DBA Data[Home] [Help]

APPS.BEN_BENUAAUD_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 74: ben_benefit_actions b

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

Line 84: ben_benefit_actions b

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

Line 95: ben_benefit_actions b

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