APPS.WIP_OSP dependencies on HR_ORGANIZATION_INFORMATION

Line 156: from HR_ORGANIZATION_INFORMATION

152: -- workflow because Req Import need this information.
153: -- get the OU, set context for MOAC.
154:
155: select to_number(ORG_INFORMATION3) into l_ou_id
156: from HR_ORGANIZATION_INFORMATION
157: where ORGANIZATION_ID = p_organization_id
158: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
159:
160: FND_REQUEST.SET_ORG_ID (l_ou_id);

Line 275: from HR_ORGANIZATION_INFORMATION

271: -- workflow because Req Import need this information.
272: -- get the OU, set context for MOAC.
273:
274: select to_number(ORG_INFORMATION3) into l_ou_id
275: from HR_ORGANIZATION_INFORMATION
276: where ORGANIZATION_ID = p_organization_id
277: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
278:
279: FND_REQUEST.SET_ORG_ID (l_ou_id);

Line 338: from HR_ORGANIZATION_INFORMATION

334: if(l_launch_req_import = WIP_CONSTANTS.YES) then
335:
336: -- get the OU, set context for MOAC
337: select to_number(ORG_INFORMATION3) into l_ou_id
338: from HR_ORGANIZATION_INFORMATION
339: where ORGANIZATION_ID = p_organization_id
340: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
341: FND_REQUEST.SET_ORG_ID (l_ou_id);
342:

Line 563: HR_ORGANIZATION_INFORMATION hoi,

559: x_project_id,
560: x_task_id,
561: DECODE(x_project_id,NULL,NULL,'Y')
562: FROM WIP_REPETITIVE_SCHEDULES wrs,
563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

Line 747: HR_ORGANIZATION_INFORMATION hoi,

743: x_project_id,
744: x_task_id,
745: DECODE(x_project_id,NULL,NULL,'Y')
746: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

Line 840: from HR_ORGANIZATION_INFORMATION

836: IF (P_Run_ReqImport = WIP_CONSTANTS.YES) THEN
837:
838: -- get the OU, set context for MOAC
839: select to_number(ORG_INFORMATION3) into l_ou_id
840: from HR_ORGANIZATION_INFORMATION
841: where ORGANIZATION_ID = p_organization_id
842: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
843: FND_REQUEST.SET_ORG_ID (l_ou_id);
844: