APPS.WIP_TIME_ENTRY_PUB dependencies on MTL_PARAMETERS

Line 49: from mtl_parameters

45: end if;
46:
47: select organization_code
48: into l_org_code
49: from mtl_parameters
50: where organization_id = p_organization_id;
51:
52: wip_ws_util.trace_log('Launching Import Time Entry Records for Organization: '||l_org_code);
53:

Line 95: from mtl_parameters mp

91: time_entry_type = 1
92: and process_status = wip_constants.pending
93: and (organization_id = p_organization_id or
94: organization_code = (select mp.organization_code
95: from mtl_parameters mp
96: where mp.organization_id = p_organization_id));
97:
98: l_status := sql%rowcount;
99: if l_status>0 then

Line 139: from mtl_parameters mp

135: time_entry_type = 3
136: and process_status = wip_constants.pending
137: and (organization_id = p_organization_id or
138: organization_code = (select mp.organization_code
139: from mtl_parameters mp
140: where mp.organization_id = p_organization_id));
141:
142: l_count := sql%rowcount;
143: l_status := l_status+l_count;

Line 178: from mtl_parameters mp

174: time_entry_type = 1
175: and process_status = wip_constants.pending
176: and (organization_id = p_organization_id or
177: organization_code = (select mp.organization_code
178: from mtl_parameters mp
179: where mp.organization_id = p_organization_id));
180:
181: l_count := sql%rowcount;
182: l_status := l_status+l_count;

Line 209: from mtl_parameters mp

205: time_entry_type = 3
206: and process_status = wip_constants.pending
207: and (organization_id = p_organization_id or
208: organization_code = (select mp.organization_code
209: from mtl_parameters mp
210: where mp.organization_id = p_organization_id));
211:
212: l_count := sql%rowcount;
213: l_status := l_status+l_count;

Line 235: from mtl_parameters mp

231: where
232: process_status = wip_constants.pending
233: and (organization_id = p_organization_id or
234: organization_code = (select mp.organization_code
235: from mtl_parameters mp
236: where mp.organization_id = p_organization_id));
237:
238: l_stmt_num := 55;
239: /* Added for Bug 6908314. This SQL will default employee_id from badge_id. */