[Home] [Help]
391: # created by Sandeep 12.Oct.1998
392: # converted from PLL to Stored Proc by Tony Ricci 10/30/98
393: # major changes included using PL/SQL tables instead of RECORD GROUPS
394: #
395: # 21-JUN-1999 Tony Ricci change order by in select from gl_accu_map
396: # B931936
397: # B1377089 RVK 31-Aug-2000 Some of the PO's were not getting
398: # updated with proper AAP and PPV accts as P_acqui_cost_id was not getting
399: # initialized. Also subledger update was failing due to uninitialized id
435: mst.orgn_code = ic.orgn_code;
436:
437: CURSOR Cur_acctg_unit_id IS
438: SELECT acctg_unit_id
439: FROM gl_accu_map
440: WHERE co_code = X_co_code and
441: (orgn_code = V_orgn_code or orgn_code IS NULL) and
442: (whse_code = V_to_whse or whse_code IS NULL) and
443: delete_mark = 0
789: # If success, returns acctg_unit_no ELSE null.
790: # HISTORY
791: # created by Sandeep 12.0ct.1998
792: #
793: # 21-JUN-1999 Tony Ricci change order by in select from gl_accu_map
794: # B931936
795: # 21-JUN-1999 Tony Ricci add login to select and check map_orgn_ind
796: # B931936
797: ############################################################################*/
811:
812: /* RVK B1394532 */
813: CURSOR Cur_acctg_unit_id (vc_orgn_code VARCHAR2) IS
814: SELECT acctg_unit_id , orgn_code , whse_code
815: FROM gl_accu_map
816: WHERE co_code = P_whse_co_code and
817: (orgn_code = vc_orgn_code or orgn_code IS NULL) and
818: (whse_code = P_to_whse or whse_code IS NULL) and
819: delete_mark = 0