74: --**********************************************************************************************
75:
76: PROCEDURE load_class_code IS
77:
78: type t_wlji_org2 is table of wip_accounting_classes.organization_id%type;
79: type t_wlji_cc is table of wip_accounting_classes.class_code%type;
80:
81: v_wlji_org2 t_wlji_org2 := t_wlji_org2();
82: v_wlji_cc t_wlji_cc := t_wlji_cc();
75:
76: PROCEDURE load_class_code IS
77:
78: type t_wlji_org2 is table of wip_accounting_classes.organization_id%type;
79: type t_wlji_cc is table of wip_accounting_classes.class_code%type;
80:
81: v_wlji_org2 t_wlji_org2 := t_wlji_org2();
82: v_wlji_cc t_wlji_cc := t_wlji_cc();
83:
83:
84: cursor c_wsm_wac is
85: select organization_id,
86: class_code
87: from wip_accounting_classes
88: where nvl(disable_date, sysdate+2) > sysdate
89: and class_type = 5 ;
90:
91: