APPS.CST_ACCRUAL_LOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 2691: FROM hr_organization_information hoi

2687: )
2688: AND mmt.transaction_date between p_from_date AND p_to_date
2689: AND EXISTS (
2690: SELECT 1
2691: FROM hr_organization_information hoi
2692: WHERE hoi.organization_id = mmt.organization_id
2693: AND hoi.org_information_context = 'Accounting Information'
2694: AND to_number(hoi.org_information3) = p_operating_unit
2695: )

Line 2818: FROM hr_organization_information hoi

2814: AND mmt.transaction_id = NVL(xte.source_id_int_1,(-99))
2815: AND mmt.transaction_date between p_from_date AND p_to_date
2816: AND EXISTS (
2817: SELECT 1
2818: FROM hr_organization_information hoi
2819: WHERE hoi.organization_id = mmt.organization_id
2820: AND hoi.org_information_context = 'Accounting Information'
2821: AND to_number(hoi.org_information3) = p_operating_unit
2822: )

Line 2867: hr_organization_information hoi1,

2863: SET cmr.vendor_id = (
2864: SELECT mip.vendor_id
2865: FROM mtl_material_transactions mmt,
2866: mtl_intercompany_parameters mip,
2867: hr_organization_information hoi1,
2868: hr_organization_information hoi2
2869: WHERE mmt.transaction_id = cmr.inventory_transaction_id
2870: AND hoi1.org_information_context = 'Accounting Information'
2871: AND hoi1.organization_id = decode(mmt.transaction_action_id,

Line 2868: hr_organization_information hoi2

2864: SELECT mip.vendor_id
2865: FROM mtl_material_transactions mmt,
2866: mtl_intercompany_parameters mip,
2867: hr_organization_information hoi1,
2868: hr_organization_information hoi2
2869: WHERE mmt.transaction_id = cmr.inventory_transaction_id
2870: AND hoi1.org_information_context = 'Accounting Information'
2871: AND hoi1.organization_id = decode(mmt.transaction_action_id,
2872: 12,mmt.transfer_organization_id,