APPS.PA_ACCUM_SRW dependencies on PA_TXN_ACCUM

Line 955: PA_TXN_ACCUM PTA

951: + NVL(SUM(I_TOT_BILLABLE_QUANTITY),0) TXN_BILLABLE_QUANTITY,
952: NVL(SUM(TOT_BILLABLE_LABOR_HOURS),0)
953: + NVL(SUM(I_TOT_BILLABLE_LABOR_HOURS),0) TXN_BILLABLE_LABOR_HOURS
954: FROM
955: PA_TXN_ACCUM PTA
956: WHERE
957: PROJECT_ID = X_PROJECT_ID
958: AND exists
959: ( SELECT 'Yes'

Line 960: FROM pa_txn_accum_details ptad

956: WHERE
957: PROJECT_ID = X_PROJECT_ID
958: AND exists
959: ( SELECT 'Yes'
960: FROM pa_txn_accum_details ptad
961: WHERE pta.txn_accum_id = ptad.txn_accum_id
962: AND ptad.line_type IN ('C','R','E')
963: )
964: GROUP BY PROJECT_ID;