APPS.JAI_PO_PROC_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 639: FROM org_organization_definitions

635:
636: CURSOR fetch_book_id_cur
637: IS
638: SELECT set_of_books_id
639: FROM org_organization_definitions
640: WHERE operating_unit = v_org_id;
641: CURSOR cur_get_curr_code IS
642: SELECT
643: sob.currency_code

Line 3904: FROM Org_Organization_Definitions

3900: WHERE requisition_line_id = pn_requisition_line_id;*/
3901:
3902: CURSOR Fetch_Org_Id_Cur(p_Destination_Organization_Id NUMBER) IS
3903: SELECT NVL(Operating_Unit,0)
3904: FROM Org_Organization_Definitions
3905: WHERE Organization_Id = p_Destination_Organization_Id;
3906:
3907: CURSOR org_cur(p_requisition_Header_Id NUMBER) IS
3908: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code

Line 4097: FROM Org_Organization_Definitions

4093: WHERE requisition_Header_Id = p_requisition_Header_Id
4094: AND requisition_line_id = pr_requisition_line.requisition_line_id;--pn_requisition_line_id;
4095:
4096: CURSOR Fetch_Org_Id_Cur IS SELECT NVL(Operating_Unit,0)
4097: FROM Org_Organization_Definitions
4098: WHERE Organization_Id = v_dest_org_id;
4099:
4100: CURSOR bind_cur IS
4101: SELECT Segment1, Type_Lookup_Code, apps_source_code

Line 4455: FROM Org_Organization_Definitions

4451: WHERE requisition_line_id = pn_requisition_line_id;*/
4452:
4453: CURSOR Fetch_Org_Id_Cur(p_Destination_Organization_Id NUMBER) IS
4454: SELECT NVL(Operating_Unit,0)
4455: FROM Org_Organization_Definitions
4456: WHERE Organization_Id = p_Destination_Organization_Id;
4457:
4458: CURSOR org_cur(p_requisition_Header_Id NUMBER) IS
4459: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code