DBA Data[Home] [Help]

APPS.PA_RES_ACCUMS dependencies on PA_TXN_ACCUM_DETAILS

Line 1000: FROM pa_txn_accum_details ptad

996: 'F',pta.cmt_rollup_flag,
997: pta.cmt_rollup_flag)))
998: AND EXISTS
999: ( SELECT 'Yes'
1000: FROM pa_txn_accum_details ptad
1001: WHERE pta.txn_accum_id = ptad.txn_accum_id
1002: );
1003:
1004: txnaccumrec seltxnaccums%ROWTYPE;

Line 1716: FROM pa_txn_accum_details ptad

1712: 'F',pta.cmt_rollup_flag,
1713: pta.cmt_rollup_flag))) 5571792 */
1714: AND EXISTS
1715: (SELECT 'Yes'
1716: FROM pa_txn_accum_details ptad
1717: WHERE pta.txn_accum_id = ptad.txn_accum_id
1718: /* following not exists will be valid even in case of refresh ( x_mode = 'F' )
1719: because from refresh process we call map_txns only after we have
1720: deleted records from pa_resource_accum_details table */

Line 1773: FROM pa_txn_accum_details ptad

1769: FROM pa_txn_accum pta
1770: WHERE pta.project_id = x_project_id
1771: AND EXISTS
1772: (SELECT 'Yes'
1773: FROM pa_txn_accum_details ptad
1774: WHERE pta.txn_accum_id = ptad.txn_accum_id
1775: /* following not exists will be valid even in case of refresh ( x_mode = 'F' )
1776: because from refresh process we call map_txns only after we have
1777: deleted records from pa_resource_accum_details table */