[Home] [Help]
783: AND l.line_num_reversed is null
784: AND l.draft_revenue_num = X_rev_inv_num)
785: AND EXISTS
786: (SELECT vt.event_type
787: FROM pa_event_types vt
788: WHERE vt.event_type_classification||'' = 'AUTOMATIC'
789: AND vt.event_type = v.event_type)
790: AND v.calling_process = X_calling_process;
791: IF g1_debug_mode = 'Y' THEN
1349: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1350: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1351: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1352: PA_DRAFT_REVENUES_ALL DR,
1353: PA_EVENT_TYPES ET,
1354: PA_EVENTS E
1355: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1356: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1357: AND E.EVENT_NUM = ERDL.EVENT_NUM
1378: DECODE(p_funding_flag,'Y',SUM(NVL(ERDL.funding_revenue_amount,0)),0)
1379: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1380: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1381: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1382: PA_EVENT_TYPES ET,
1383: PA_EVENTS E
1384: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1385: AND E.EVENT_NUM = ERDL.EVENT_NUM
1386: AND E.TASK_ID = ERDL.TASK_ID
1396: /* SELECT SUM(NVL(E.revenue_amount,0)),SUM(NVL(E.project_revenue_amount,0)),
1397: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1398: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1399: x_projfunc_writeoff_amount,p_writeoff_amount
1400: FROM PA_EVENT_TYPES ET,
1401: PA_EVENTS E
1402: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1403: AND ET.EVENT_TYPE = E.EVENT_TYPE
1404: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1423: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1424: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1425: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1426: PA_DRAFT_REVENUES_ALL DR,
1427: PA_EVENT_TYPES ET,
1428: PA_EVENTS E
1429: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1430: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1431: 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 ET.EVENT_TYPE = E.EVENT_TYPE
1466: SELECT SUM(NVL(E.revenue_amount,0)),SUM(NVL(E.project_revenue_amount,0)),
1467: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1468: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1469: x_projfunc_writeoff_amount,p_writeoff_amount
1470: FROM PA_EVENT_TYPES ET,
1471: PA_EVENTS E
1472: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1473: AND ET.EVENT_TYPE = E.EVENT_TYPE
1474: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1488: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1489: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1490: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1491: PA_DRAFT_REVENUES_ALL DR,
1492: PA_EVENT_TYPES ET,
1493: PA_EVENTS E
1494: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1495: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1496: AND E.EVENT_NUM = ERDL.EVENT_NUM
1514: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1515: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1516: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1517: PA_DRAFT_REVENUES_ALL DR,
1518: PA_EVENT_TYPES ET,
1519: PA_EVENTS E
1520: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1521: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1522: AND E.EVENT_NUM = ERDL.EVENT_NUM