DBA Data[Home] [Help]

APPS.GMF_ALLOC_PROCESS_PRIVATE dependencies on GL_PLCY_SEG

Line 51: FROM gl_plcy_seg

47: WHERE co_code = v_co_code;
48:
49: CURSOR Cur_segtypecnt(v_type IN NUMBER) IS
50: SELECT COUNT(1)
51: FROM gl_plcy_seg
52: WHERE co_code = v_co_code
53: AND type = v_type;
54:
55: CURSOR Cur_segment_type(v_type IN NUMBER) IS

Line 59: FROM gl_plcy_seg

55: CURSOR Cur_segment_type(v_type IN NUMBER) IS
56: SELECT segment_no,
57: length,
58: short_name
59: FROM gl_plcy_seg
60: WHERE co_code = v_co_code
61: AND type = v_type
62: ORDER BY 1 ASC;
63:

Line 66: FROM gl_plcy_seg

62: ORDER BY 1 ASC;
63:
64: CURSOR Cur_segment_cnt IS
65: SELECT COUNT(1)
66: FROM gl_plcy_seg
67: WHERE co_code = v_co_code;
68:
69: x_a NUMBER(8) DEFAULT 0; /* stores accts start position*/
70: x_deli_au_len NUMBER(10) DEFAULT 0; /* sotres AU length*/