APPS.CST_PRJMFG_COST_COLLECTOR dependencies on HR_ORGANIZATION_INFORMATION

Line 2660: from hr_organization_information

2656:
2657: l_stmt_num := 16;
2658: select org_information3
2659: into l_operating_unit
2660: from hr_organization_information
2661: where organization_id = p_organization_id
2662: and org_information_context ='Accounting Information';
2663:
2664: l_stmt_num :=17;

Line 5674: from hr_organization_information

5670: /* Bug 5308514 - Setting the OU context for the current organization */
5671: l_stmt_num := 16;
5672: select org_information3
5673: into l_operating_unit
5674: from hr_organization_information
5675: where organization_id = p_organization_id
5676: and org_information_context ='Accounting Information';
5677:
5678: l_stmt_num :=17;

Line 5738: from hr_organization_information

5734: /* bug 3742735. The org_id passed should be the org_id where the transaction happened and not the OU on the project. */
5735:
5736: select to_number(org_information3)
5737: into l_multi_org_id
5738: from hr_organization_information
5739: where organization_id = p_organization_id
5740: and org_information_context ='Accounting Information';
5741:
5742:

Line 7357: from hr_organization_information hoi,

7353: /* Bug 3742735. Pass the org_id of the organization on the txn always.This will enable cross project charging to also work. */
7354:
7355: select to_number(org_information3)
7356: into l_op_unit
7357: from hr_organization_information hoi,
7358: mtl_material_transactions mmt
7359: where hoi.organization_id = mmt.organization_id
7360: and mmt.transaction_id = to_number(p_orig_transaction_reference)
7361: and org_information_context ='Accounting Information';