APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_EVENT_TYPES

Line 439: PA_EVENT_TYPES ET,

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
443: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID

Line 468: PA_EVENT_TYPES ET,

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
472: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID

Line 500: PA_EVENT_TYPES ET,

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
504: AND V.EVENT_TYPE = ET.EVENT_TYPE

Line 1476: PA_EVENT_TYPES ET

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
1480: AND NVL(V.BILL_TRANS_REV_AMOUNT,0) <> 0

Line 1581: PA_EVENT_TYPES ET,

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
1585: AND V.EVENT_DATE >= NVL(l_etc_start_date, V.EVENT_DATE)