DBA Data[Home] [Help]

APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_FIN7_OLAP

Line 1206: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

1202: tmp7.BILL_QUANTITY,
1203: tmp7.cbs_version_id,
1204: tmp7.cbs_element_id
1205: from
1206: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
1207: pa_projects_all pa, pa_pjt_proj_batch batch
1208: where
1209: g_extraction_type = 'INCREMENTAL'
1210: and tmp7.project_id = proj_batch.project_id (+) and

Line 1283: PA_FIN7_OLAP fin7,

1279: bal.BILL_QUANTITY,
1280: bal.cbs_version_id,
1281: bal.cbs_element_id
1282: from PJI_FP_TXN_ACCUM bal,
1283: PA_FIN7_OLAP fin7,
1284: pa_projects_all pa,
1285: pa_pjt_proj_batch batch
1286: where
1287: g_extraction_type = 'INCREMENTAL' and

Line 1644: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

1640: tmp7.BILL_QUANTITY,
1641: tmp7.cbs_version_id,
1642: tmp7.cbs_element_id
1643: from
1644: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
1645: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch
1646: where
1647: g_extraction_type = 'INCREMENTAL'
1648: and tmp7.project_id = proj_batch.project_id (+) and

Line 1724: PA_FIN7_OLAP fin7,

1720: bal.cbs_version_id,
1721: bal.cbs_element_id
1722: from PJI_FP_TXN_ACCUM bal,
1723: PA_RBS_PRJ_ASSIGNMENTS asg,
1724: PA_FIN7_OLAP fin7,
1725: pa_projects_all pa,
1726: pa_pjt_proj_batch batch
1727: where
1728: g_extraction_type = 'INCREMENTAL' and

Line 2096: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

2092: tmp7.BILL_QUANTITY,
2093: tmp7.cbs_version_id,
2094: tmp7.cbs_element_id
2095: from
2096: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
2097: pa_projects_all pa, pa_pjt_proj_batch batch
2098: where
2099: g_extraction_type = 'INCREMENTAL'
2100: and tmp7.project_id = proj_batch.project_id (+) and

Line 2174: PA_FIN7_OLAP fin7,

2170: bal.BILL_QUANTITY,
2171: bal.cbs_version_id,
2172: bal.cbs_element_id
2173: from PJI_FP_TXN_ACCUM bal,
2174: PA_FIN7_OLAP fin7,
2175: pa_projects_all pa,
2176: pa_pjt_proj_batch batch
2177: where
2178: g_extraction_type = 'INCREMENTAL' and

Line 2539: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,

2535: tmp7.BILL_QUANTITY,
2536: tmp7.cbs_version_id,
2537: tmp7.cbs_element_id
2538: from
2539: PA_FIN7_OLAP tmp7, PA_STAGE1_BATCH_OLAP proj_batch,
2540: PA_RBS_PRJ_ASSIGNMENTS asg, pa_projects_all pa, pa_pjt_proj_batch batch
2541: where
2542: g_extraction_type = 'INCREMENTAL'
2543: and tmp7.project_id = proj_batch.project_id (+) and

Line 2620: PA_FIN7_OLAP fin7,

2616: bal.cbs_version_id,
2617: bal.cbs_element_id
2618: from PJI_FP_TXN_ACCUM bal,
2619: PA_RBS_PRJ_ASSIGNMENTS asg,
2620: PA_FIN7_OLAP fin7,
2621: pa_projects_all pa,
2622: pa_pjt_proj_batch batch
2623: where
2624: g_extraction_type = 'INCREMENTAL' and