APPS.WIP_OSP dependencies on HR_ORGANIZATION_INFORMATION

Line 168: from HR_ORGANIZATION_INFORMATION

164: -- workflow because Req Import need this information.
165: -- get the OU, set context for MOAC.
166:
167: select to_number(ORG_INFORMATION3) into l_ou_id
168: from HR_ORGANIZATION_INFORMATION
169: where ORGANIZATION_ID = p_organization_id
170: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
171:
172: FND_REQUEST.SET_ORG_ID (l_ou_id);

Line 288: from HR_ORGANIZATION_INFORMATION

284: -- workflow because Req Import need this information.
285: -- get the OU, set context for MOAC.
286:
287: select to_number(ORG_INFORMATION3) into l_ou_id
288: from HR_ORGANIZATION_INFORMATION
289: where ORGANIZATION_ID = p_organization_id
290: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
291:
292: FND_REQUEST.SET_ORG_ID (l_ou_id);

Line 352: from HR_ORGANIZATION_INFORMATION

348: if(l_launch_req_import = WIP_CONSTANTS.YES) then
349:
350: -- get the OU, set context for MOAC
351: select to_number(ORG_INFORMATION3) into l_ou_id
352: from HR_ORGANIZATION_INFORMATION
353: where ORGANIZATION_ID = p_organization_id
354: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
355: FND_REQUEST.SET_ORG_ID (l_ou_id);
356:

Line 611: HR_ORGANIZATION_INFORMATION hoi,

607: x_project_id,
608: x_task_id,
609: DECODE(x_project_id,NULL,NULL,'Y')
610: FROM WIP_REPETITIVE_SCHEDULES wrs,
611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

Line 804: HR_ORGANIZATION_INFORMATION hoi,

800: x_project_id,
801: x_task_id,
802: DECODE(x_project_id,NULL,NULL,'Y')
803: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,

Line 897: from HR_ORGANIZATION_INFORMATION

893: IF (P_Run_ReqImport = WIP_CONSTANTS.YES) THEN
894:
895: -- get the OU, set context for MOAC
896: select to_number(ORG_INFORMATION3) into l_ou_id
897: from HR_ORGANIZATION_INFORMATION
898: where ORGANIZATION_ID = p_organization_id
899: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
900: FND_REQUEST.SET_ORG_ID (l_ou_id);
901: