DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 863: --lvenkatr 07/06/2012: Modified code to obtain OU from Inv Org from Org_Organization_Definitions

859: vl_debug varchar2(4000);
860:
861: BEGIN
862:
863: --lvenkatr 07/06/2012: Modified code to obtain OU from Inv Org from Org_Organization_Definitions
864: -- instead of hr_organization_information
865:
866: SELECT ood.operating_unit
867: INTO lp_org_id

Line 868: FROM org_organization_definitions ood

864: -- instead of hr_organization_information
865:
866: SELECT ood.operating_unit
867: INTO lp_org_id
868: FROM org_organization_definitions ood
869: WHERE ood.organization_id=p_org_id;
870:
871: /** Commented on 07/06/2012
872: --ssurendr: Added code to obtain OU from Inv Org