APPS.PA_RBS_MAPPING dependencies on PA_RBS_MAP_T1

Line 1930: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;

1926:
1927: --AECOM Change END
1928:
1929: /* AWE Fix for bug 13727835 starts */
1930: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
1931:
1932: --Commented the above insert and adding below for VTT 10246359
1933: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)
1934: WITH gmap as (select * from PJI_PJP_PROJ_BATCH_MAP MAP

Line 1933: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)

1929: /* AWE Fix for bug 13727835 starts */
1930: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
1931:
1932: --Commented the above insert and adding below for VTT 10246359
1933: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)
1934: WITH gmap as (select * from PJI_PJP_PROJ_BATCH_MAP MAP
1935: where MAP.WORKER_ID = p_worker_id )
1936: SELECT DISTINCT p_worker_id , PROJECT_ID, TXN_ACCUM_HEADER_ID
1937: FROM (

Line 2014: --test_logmessage('RBS',1000,' After insert into pa_rbs_map_t1 sql%rowcount '||sql%rowcount );

2010: AND HD2.PLAN_VERSION_ID = RA.BUDGET_VERSION_ID
2011: AND HD2.PROJECT_ID = RA.PROJECT_ID );
2012: --End of VTT 10246359
2013:
2014: --test_logmessage('RBS',1000,' After insert into pa_rbs_map_t1 sql%rowcount '||sql%rowcount );
2015:
2016: /* bug#3651414 added join with rbs version and rbs header tables
2017: bug#3826585 added lookup to FIN7 and txn accum for project and txn accum header*/
2018:

Line 2031: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id

2027: FROM (SELECT
2028: project_id,
2029: txn_accum_header_id
2030: FROM
2031: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id
2032: ) det,
2033: pa_rbs_prj_assignments ASSIGN,
2034: pa_rbs_versions_b rbsv,
2035: pa_rbs_headers_b rbsh

Line 2051: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;

2047: NVL(rbsh.effective_to_date,SYSDATE);
2048:
2049: --test_logmessage('RBS',1000,' After insert into pa_rbs_map_tmp1 sql%rowcount '||sql%rowcount );
2050:
2051: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
2052:
2053: --test_logmessage('RBS',1000,' After delete from pa_rbs_map_t1 sql%rowcount '||sql%rowcount );
2054: /* AWE Fix for bug 13727835 ends */
2055:

Line 2053: --test_logmessage('RBS',1000,' After delete from pa_rbs_map_t1 sql%rowcount '||sql%rowcount );

2049: --test_logmessage('RBS',1000,' After insert into pa_rbs_map_tmp1 sql%rowcount '||sql%rowcount );
2050:
2051: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
2052:
2053: --test_logmessage('RBS',1000,' After delete from pa_rbs_map_t1 sql%rowcount '||sql%rowcount );
2054: /* AWE Fix for bug 13727835 ends */
2055:
2056: IF (l_extraction_type = 'RBS') THEN
2057:

Line 2317: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;

2313:
2314:
2315: l_extraction_type := p_calling_mode ;
2316:
2317: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
2318:
2319:
2320: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)
2321: SELECT DISTINCT p_worker_id , PROJECT_ID, TXN_ACCUM_HEADER_ID

Line 2320: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)

2316:
2317: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
2318:
2319:
2320: INSERT INTO PA_RBS_MAP_T1 (WORKER_ID , PROJECT_ID , TXN_ACCUM_HEADER_ID)
2321: SELECT DISTINCT p_worker_id , PROJECT_ID, TXN_ACCUM_HEADER_ID
2322: FROM (
2323: SELECT /*+ ordered USE_NL(map, fin7) index(fin7 pji_fm_aggr_fin7_n1) */
2324: FIN7.PROJECT_ID, TXN_ACCUM_HEADER_ID

Line 2365: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id

2361: FROM (SELECT
2362: distinct
2363: txn_accum_header_id
2364: FROM
2365: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id
2366: ) det,
2367: pa_rbs_prj_assignments ASSIGN,
2368: pa_rbs_versions_b rbsv,
2369: pa_rbs_headers_b rbsh