APPS.GMF_ALLOC_PROC dependencies on GL_ALOC_BAS

Line 310: FROM gl_aloc_mst m,gl_aloc_bas b

306: WHERE period_id = g_period_id
307: AND cost_type_id = g_cost_type_id
308: AND (alloc_id,line_no) NOT IN (
309: SELECT b.alloc_id, b.line_no
310: FROM gl_aloc_mst m,gl_aloc_bas b
311: WHERE m.alloc_id = b.alloc_id
312: AND m.legal_entity_id = g_legal_entity_id
313: AND b.delete_mark = 0
314: AND m.delete_mark = 0

Line 575: FROM gl_aloc_mst m, gl_aloc_bas b

571:
572: CURSOR cur_alloc_fixed_invalid IS
573: SELECT m.alloc_code alloc_code,
574: sum(b.fixed_percent) total_percentage
575: FROM gl_aloc_mst m, gl_aloc_bas b
576: WHERE m.alloc_id = b.alloc_id
577: AND m.legal_entity_id = g_legal_entity_id
578: AND b.alloc_method = 1
579: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code)

Line 723: from gl_aloc_bas b

719: and a.alloc_code between nvl(v_from_alloc_code,a.alloc_code) and
720: nvl(v_to_alloc_code,a.alloc_code)
721: and 100 =
722: (select decode(max(b.alloc_method), 0, 100, 1, sum(fixed_percent))
723: from gl_aloc_bas b
724: where b.alloc_id = a.alloc_id
725: and b.delete_mark = 0
726: )
727: ;

Line 1160: FROM gl_aloc_mst m, gl_aloc_bas b

1156: b.basis_account_id,
1157: b.balance_type,
1158: b.bas_ytd_ptd,
1159: b.fixed_percent
1160: FROM gl_aloc_mst m, gl_aloc_bas b
1161: WHERE m.alloc_id = b.alloc_id
1162: AND m.legal_entity_id = g_legal_entity_id
1163: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1164: AND m.delete_mark = 0

Line 1168: FROM gl_aloc_bas bb

1164: AND m.delete_mark = 0
1165: AND b.delete_mark = 0
1166: AND (b.alloc_method = 0 OR
1167: (b.alloc_method = 1 AND 100 = ( SELECT sum(bb.fixed_percent)
1168: FROM gl_aloc_bas bb
1169: WHERE bb.alloc_id = b.alloc_id and
1170: bb.delete_mark = 0
1171: )
1172: )

Line 1232: FROM gl_aloc_mst m, gl_aloc_bas b

1228: SELECT m.alloc_id,
1229: b.line_no,
1230: b.alloc_method,
1231: b.fixed_percent
1232: FROM gl_aloc_mst m, gl_aloc_bas b
1233: WHERE m.alloc_id = b.alloc_id
1234: AND m.legal_entity_id = g_legal_entity_id
1235: AND b.alloc_method = 1
1236: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)

Line 1240: FROM gl_aloc_bas bb

1236: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1237: AND m.delete_mark = 0
1238: AND b.delete_mark = 0
1239: AND 100 = ( SELECT sum(bb.fixed_percent)
1240: FROM gl_aloc_bas bb
1241: WHERE bb.alloc_id = b.alloc_id and
1242: bb.delete_mark = 0
1243: )
1244: ORDER BY 1,2;

Line 1260: from gl_aloc_mst m,gl_aloc_bas b

1256: and a.calendar_code = g_calendar_code
1257: AND a.period_code = g_period_code
1258: and a.alloc_id in (
1259: select m.alloc_id
1260: from gl_aloc_mst m,gl_aloc_bas b
1261: where m.legal_entity_id = g_legal_entity_id
1262: and m.alloc_id = b.alloc_id
1263: and b.alloc_method = 1
1264: and m.alloc_code between nvl(v_from_alloc_code,m.alloc_code)

Line 1340: FROM gl_aloc_mst m,gl_aloc_bas b

1336: AND i.period_code = g_period_code
1337: AND i.delete_mark = 0
1338: AND account_key_type = 0
1339: AND i.alloc_id IN (SELECT b.alloc_id
1340: FROM gl_aloc_mst m,gl_aloc_bas b
1341: where m.alloc_id = b.alloc_id
1342: AND m.legal_entity_id = g_legal_entity_id
1343: AND b.delete_mark = 0
1344: AND m.delete_mark = 0