DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 71: FROM Org_Organization_Definitions

67: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
68:
69: CURSOR Fetch_Org_Id_Cur IS
70: SELECT NVL(Operating_Unit,0)
71: FROM Org_Organization_Definitions
72: WHERE Organization_Id = v_dest_org_id;
73:
74: CURSOR org_cur IS
75: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code--added apps_source_code by rchandan for bug#4627239

Line 1921: FROM Org_Organization_Definitions

1917: */
1918: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1919:
1920: CURSOR Fetch_Org_Id_Cur IS SELECT NVL(Operating_Unit,0)
1921: FROM Org_Organization_Definitions
1922: WHERE Organization_Id = v_dest_org_id;
1923:
1924: CURSOR bind_cur IS
1925: SELECT Segment1, Type_Lookup_Code, apps_source_code -- pramasub FP

Line 2761: FROM Org_Organization_Definitions

2757: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2758:
2759: ------------------------------------------------------------------------------------------------
2760: CURSOR Fetch_Org_Id_Cur IS SELECT nvl(Operating_Unit,0)
2761: FROM Org_Organization_Definitions
2762: WHERE Organization_Id = v_dest_org_id;
2763:
2764: Cursor bind_cur IS SELECT Segment1, Type_Lookup_Code
2765: FROM Po_Requisition_Headers_All