DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 65: FROM Org_Organization_Definitions

61: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
62:
63: CURSOR Fetch_Org_Id_Cur IS
64: SELECT NVL(Operating_Unit,0)
65: FROM Org_Organization_Definitions
66: WHERE Organization_Id = v_dest_org_id;
67:
68: CURSOR org_cur IS
69: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code--added apps_source_code by rchandan for bug#4627239

Line 1790: FROM Org_Organization_Definitions

1786: */
1787: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1788:
1789: CURSOR Fetch_Org_Id_Cur IS SELECT NVL(Operating_Unit,0)
1790: FROM Org_Organization_Definitions
1791: WHERE Organization_Id = v_dest_org_id;
1792:
1793: CURSOR bind_cur IS
1794: SELECT Segment1, Type_Lookup_Code, apps_source_code -- pramasub FP

Line 2538: FROM Org_Organization_Definitions

2534: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2535:
2536: ------------------------------------------------------------------------------------------------
2537: CURSOR Fetch_Org_Id_Cur IS SELECT nvl(Operating_Unit,0)
2538: FROM Org_Organization_Definitions
2539: WHERE Organization_Id = v_dest_org_id;
2540:
2541: Cursor bind_cur IS SELECT Segment1, Type_Lookup_Code
2542: FROM Po_Requisition_Headers_All