DBA Data[Home] [Help]

APPS.PA_TXN_ACCUMS dependencies on PA_COMMITMENT_TXNS_TMP

Line 1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';

1362: IF x_use_tmp_table = 'N' THEN /* 14457478 */
1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1365: ELSIF x_use_tmp_table = 'Y' THEN
1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';
1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1368: END IF; /* 14457478 */
1369: END IF;
1370:

Line 1801: pa_commitment_txns_tmp pctv

1797: pctv.wip_resource_id,
1798: pctv.wip_resource_id,
1799: pctv.resource_class
1800: FROM
1801: pa_commitment_txns_tmp pctv
1802: WHERE
1803: pctv.project_id = x_start_project_id
1804: /* 14457478 */
1805: AND pctv.PROJECT_ID IS NOT NULL

Line 2493: pa_commitment_txns_tmp pctv

2489: pctv.WIP_RESOURCE_ID BOM_LABOR_RESOURCE_ID,
2490: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2491: pctv.RESOURCE_CLASS
2492: from
2493: pa_commitment_txns_tmp pctv
2494: WHERE
2495: pctv.PROJECT_ID = l_project_id_1
2496: /* 14457478 */
2497: AND pctv.PROJECT_ID IS NOT NULL