[Home] [Help]
85: AND (select decode(et.event_type_classification,
86: 'INVOICE REDUCTION',
87: -e.bill_trans_bill_amount,
88: e.bill_trans_bill_amount)
89: from pa_event_types et
90: where et.event_type = e.event_type
91: )
92: in ( select /*+ INDEX(i PA_DRAFT_INVOICE_ITEMS_N2)*/ SUM(i.bill_trans_bill_amount)
93: from pa_draft_invoice_items i ,
844: AND l.line_num_reversed is null
845: AND l.draft_revenue_num = X_rev_inv_num)
846: AND EXISTS
847: (SELECT vt.event_type
848: FROM pa_event_types vt
849: WHERE vt.event_type_classification||'' = 'AUTOMATIC'
850: AND vt.event_type = v.event_type)
851: AND v.calling_process = X_calling_process;
852: IF g1_debug_mode = 'Y' THEN
1420: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1421: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1422: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1423: PA_DRAFT_REVENUES_ALL DR,
1424: PA_EVENT_TYPES ET,
1425: PA_EVENTS E
1426: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1427: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1428: AND E.EVENT_NUM = ERDL.EVENT_NUM
1449: DECODE(p_funding_flag,'Y',SUM(NVL(ERDL.funding_revenue_amount,0)),0)
1450: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1451: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1452: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1453: PA_EVENT_TYPES ET,
1454: PA_EVENTS E
1455: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1456: AND E.EVENT_NUM = ERDL.EVENT_NUM
1457: AND E.TASK_ID = ERDL.TASK_ID
1467: /* SELECT SUM(NVL(E.revenue_amount,0)),SUM(NVL(E.project_revenue_amount,0)),
1468: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1469: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1470: x_projfunc_writeoff_amount,p_writeoff_amount
1471: FROM PA_EVENT_TYPES ET,
1472: PA_EVENTS E
1473: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1474: AND ET.EVENT_TYPE = E.EVENT_TYPE
1475: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1494: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1495: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1496: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1497: PA_DRAFT_REVENUES_ALL DR,
1498: PA_EVENT_TYPES ET,
1499: PA_EVENTS E
1500: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1501: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1502: AND E.EVENT_NUM = ERDL.EVENT_NUM
1520: DECODE(p_funding_flag,'Y',SUM(NVL(ERDL.funding_revenue_amount,0)),0)
1521: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1522: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1523: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1524: PA_EVENT_TYPES ET,
1525: PA_EVENTS E
1526: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG ,'N') = 'Y'
1527: AND E.EVENT_NUM = ERDL.EVENT_NUM
1528: AND ET.EVENT_TYPE = E.EVENT_TYPE
1537: SELECT SUM(NVL(E.revenue_amount,0)),SUM(NVL(E.project_revenue_amount,0)),
1538: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1539: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1540: x_projfunc_writeoff_amount,p_writeoff_amount
1541: FROM PA_EVENT_TYPES ET,
1542: PA_EVENTS E
1543: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1544: AND ET.EVENT_TYPE = E.EVENT_TYPE
1545: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1559: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1560: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1561: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1562: PA_DRAFT_REVENUES_ALL DR,
1563: PA_EVENT_TYPES ET,
1564: PA_EVENTS E
1565: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1566: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1567: AND E.EVENT_NUM = ERDL.EVENT_NUM
1585: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1586: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1587: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1588: PA_DRAFT_REVENUES_ALL DR,
1589: PA_EVENT_TYPES ET,
1590: PA_EVENTS E
1591: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1592: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1593: AND E.EVENT_NUM = ERDL.EVENT_NUM