APPS.CST_PRJMFG_COST_COLLECTOR dependencies on HR_ORGANIZATION_INFORMATION

Line 2721: from hr_organization_information

2717:
2718: l_stmt_num := 16;
2719: select org_information3
2720: into l_operating_unit
2721: from hr_organization_information
2722: where organization_id = p_organization_id
2723: and org_information_context ='Accounting Information';
2724:
2725: l_stmt_num :=17;

Line 5741: from hr_organization_information

5737: /* Bug 5308514 - Setting the OU context for the current organization */
5738: l_stmt_num := 16;
5739: select org_information3
5740: into l_operating_unit
5741: from hr_organization_information
5742: where organization_id = p_organization_id
5743: and org_information_context ='Accounting Information';
5744:
5745: l_stmt_num :=17;

Line 5805: from hr_organization_information

5801: /* bug 3742735. The org_id passed should be the org_id where the transaction happened and not the OU on the project. */
5802:
5803: select to_number(org_information3)
5804: into l_multi_org_id
5805: from hr_organization_information
5806: where organization_id = p_organization_id
5807: and org_information_context ='Accounting Information';
5808:
5809:

Line 7594: from hr_organization_information hoi,

7590: /* Bug 3742735. Pass the org_id of the organization on the txn always.This will enable cross project charging to also work. */
7591:
7592: select to_number(org_information3)
7593: into l_op_unit
7594: from hr_organization_information hoi,
7595: mtl_material_transactions mmt
7596: where hoi.organization_id = mmt.organization_id
7597: and mmt.transaction_id = to_number(p_orig_transaction_reference)
7598: and org_information_context ='Accounting Information';