[Home] [Help]
312: AND cost_type_id = g_cost_type_id
313: AND nvl(gl_posted_ind, 0) <> 1
314: AND (alloc_id,line_no) IN
315: (SELECT b.alloc_id, b.line_no
316: FROM gl_aloc_mst m,gl_aloc_bas b
317: WHERE m.alloc_id = b.alloc_id
318: AND m.legal_entity_id = g_legal_entity_id
319: AND ( b.delete_mark = 1 OR m.delete_mark = 1)
320: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and
352: WHERE period_id = g_period_id
353: AND cost_type_id = g_cost_type_id
354: AND (alloc_id,line_no) NOT IN (
355: SELECT b.alloc_id, b.line_no
356: FROM gl_aloc_mst m,gl_aloc_bas b
357: WHERE m.alloc_id = b.alloc_id
358: AND m.legal_entity_id = g_legal_entity_id
359: AND b.delete_mark = 0
360: AND m.delete_mark = 0
435: AND cost_type_id = g_cost_type_id
436: AND nvl(gl_posted_ind, 0) <> 1 -- Bug 12561766
437: AND (alloc_id,line_no) IN (
438: SELECT b.alloc_id, b.line_no
439: FROM gl_aloc_mst m,gl_aloc_bas b
440: WHERE m.alloc_id = b.alloc_id
441: AND m.legal_entity_id = g_legal_entity_id
442: AND ( b.delete_mark = 1 OR m.delete_mark = 1)
443: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and
642: FROM gl_aloc_inp
643: WHERE calendar_code = g_calendar_code
644: AND period_code = g_period_code
645: AND alloc_id IN (SELECT b.alloc_id
646: FROM gl_aloc_mst m, gl_aloc_bas b
647: WHERE m.alloc_id = b.alloc_id
648: AND m.legal_entity_id = g_legal_entity_id
649: AND m.alloc_code BETWEEN nvl(v_from_alloc_code, m.alloc_code) AND
650: nvl(v_to_alloc_code, m.alloc_code)
711:
712: CURSOR cur_alloc_fixed_invalid IS
713: SELECT m.alloc_code alloc_code,
714: sum(b.fixed_percent) total_percentage
715: FROM gl_aloc_mst m, gl_aloc_bas b
716: WHERE m.alloc_id = b.alloc_id
717: AND m.legal_entity_id = g_legal_entity_id
718: AND b.alloc_method = 1
719: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code)
859: and a.alloc_code between nvl(v_from_alloc_code,a.alloc_code) and
860: nvl(v_to_alloc_code,a.alloc_code)
861: and 100 =
862: (select decode(max(b.alloc_method), 0, 100, 1, sum(fixed_percent))
863: from gl_aloc_bas b
864: where b.alloc_id = a.alloc_id
865: and b.delete_mark = 0
866: )
867: ;
1389: b.basis_account_id,
1390: b.balance_type,
1391: b.bas_ytd_ptd,
1392: b.fixed_percent
1393: FROM gl_aloc_mst m, gl_aloc_bas b
1394: WHERE m.alloc_id = b.alloc_id
1395: AND m.legal_entity_id = g_legal_entity_id
1396: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1397: AND m.delete_mark = 0
1397: AND m.delete_mark = 0
1398: AND b.delete_mark = 0
1399: AND (b.alloc_method = 0 OR
1400: (b.alloc_method = 1 AND 100 = ( SELECT sum(bb.fixed_percent)
1401: FROM gl_aloc_bas bb
1402: WHERE bb.alloc_id = b.alloc_id and
1403: bb.delete_mark = 0
1404: )
1405: )
1461: SELECT m.alloc_id,
1462: b.line_no,
1463: b.alloc_method,
1464: b.fixed_percent
1465: FROM gl_aloc_mst m, gl_aloc_bas b
1466: WHERE m.alloc_id = b.alloc_id
1467: AND m.legal_entity_id = g_legal_entity_id
1468: AND b.alloc_method = 1
1469: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1469: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1470: AND m.delete_mark = 0
1471: AND b.delete_mark = 0
1472: AND 100 = ( SELECT sum(bb.fixed_percent)
1473: FROM gl_aloc_bas bb
1474: WHERE bb.alloc_id = b.alloc_id and
1475: bb.delete_mark = 0
1476: )
1477: ORDER BY 1,2;
1489: and a.calendar_code = g_calendar_code
1490: AND a.period_code = g_period_code
1491: and a.alloc_id in (
1492: select m.alloc_id
1493: from gl_aloc_mst m,gl_aloc_bas b
1494: where m.legal_entity_id = g_legal_entity_id
1495: and m.alloc_id = b.alloc_id
1496: and b.alloc_method = 1
1497: and m.alloc_code between nvl(v_from_alloc_code,m.alloc_code)
1569: AND i.period_code = g_period_code
1570: AND i.delete_mark = 0
1571: AND account_key_type = 0
1572: AND i.alloc_id IN (SELECT b.alloc_id
1573: FROM gl_aloc_mst m,gl_aloc_bas b
1574: where m.alloc_id = b.alloc_id
1575: AND m.legal_entity_id = g_legal_entity_id
1576: AND b.delete_mark = 0
1577: AND m.delete_mark = 0