APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_EVENTS_DELIVERABLE_V

Line 438: FROM PA_EVENTS_DELIVERABLE_V V,

434: SUM(DECODE(ET.EVENT_TYPE_CLASSIFICATION,
435: 'WRITE OFF', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
436: 'REALIZED_LOSSES', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
437: NVL(V.BILL_TRANS_REV_AMOUNT,0)))
438: FROM PA_EVENTS_DELIVERABLE_V V,
439: PA_EVENT_TYPES ET,
440: PA_RES_LIST_MAP_TMP4 TMP,
441: PA_RESOURCE_ASSIGNMENTS P,
442: PA_PERIODS PAP

Line 467: FROM PA_EVENTS_DELIVERABLE_V V,

463: SUM(DECODE(ET.EVENT_TYPE_CLASSIFICATION,
464: 'WRITE OFF', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
465: 'REALIZED_LOSSES', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
466: NVL(V.BILL_TRANS_REV_AMOUNT,0)))
467: FROM PA_EVENTS_DELIVERABLE_V V,
468: PA_EVENT_TYPES ET,
469: PA_RES_LIST_MAP_TMP4 TMP,
470: PA_RESOURCE_ASSIGNMENTS P,
471: GL_PERIOD_STATUSES GLP

Line 499: FROM PA_EVENTS_DELIVERABLE_V V,

495: SUM(DECODE(ET.EVENT_TYPE_CLASSIFICATION,
496: 'WRITE OFF', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
497: 'REALIZED_LOSSES', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
498: NVL(V.BILL_TRANS_REV_AMOUNT,0)))
499: FROM PA_EVENTS_DELIVERABLE_V V,
500: PA_EVENT_TYPES ET,
501: PA_RES_LIST_MAP_TMP4 TMP,
502: PA_RESOURCE_ASSIGNMENTS P
503: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID

Line 670: FROM PA_EVENTS_DELIVERABLE_V

666: l_TXN_PLAN_START_DATE_tab,
667: l_TXN_PLAN_END_DATE_tab,
668: l_FC_RES_TYPE_CODE_tab,
669: l_RESOURCE_CLASS_CODE_tab
670: FROM PA_EVENTS_DELIVERABLE_V
671: WHERE PROJECT_ID = P_PROJECT_ID;
672:
673: IF l_TXN_SOURCE_ID_tab.count = 0 THEN
674: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1475: FROM PA_EVENTS_DELIVERABLE_V V,

1471: l_txn_currency_code_tab,
1472: l_txn_rev_amt_tab,
1473: l_projfunc_rev_amt_tab,
1474: l_project_rev_amt_tab
1475: FROM PA_EVENTS_DELIVERABLE_V V,
1476: PA_EVENT_TYPES ET
1477: WHERE V.PROJECT_ID = P_PROJECT_ID
1478: AND V.EVENT_DATE >= NVL(l_etc_start_date, V.EVENT_DATE)
1479: AND V.EVENT_TYPE = ET.EVENT_TYPE

Line 1580: FROM PA_EVENTS_DELIVERABLE_V V,

1576: l_txn_currency_code_tab,
1577: l_txn_rev_amt_tab,
1578: l_projfunc_rev_amt_tab,
1579: l_project_rev_amt_tab
1580: FROM PA_EVENTS_DELIVERABLE_V V,
1581: PA_EVENT_TYPES ET,
1582: PA_RES_LIST_MAP_TMP4 TMP
1583: --,PA_RESOURCE_ASSIGNMENTS RA
1584: WHERE V.PROJECT_ID = P_PROJECT_ID

Line 1818: FROM PA_EVENTS_DELIVERABLE_V

1814: l_TXN_PLAN_START_DATE_tab,
1815: l_TXN_PLAN_END_DATE_tab,
1816: l_FC_RES_TYPE_CODE_tab,
1817: l_RESOURCE_CLASS_CODE_tab
1818: FROM PA_EVENTS_DELIVERABLE_V
1819: WHERE PROJECT_ID = P_PROJECT_ID;
1820:
1821: x_txn_source_id_count := l_TXN_SOURCE_ID_tab.count;
1822: