APPS.PA_PURGE_COSTING dependencies on PA_EI_DENORM_AR

Line 1499: x_err_stack := x_err_stack || ' ->Before insert into Pa_Ei_Denorm_AR' ;

1495: -- which is also a transaction table.
1496:
1497: l_old_err_stack := x_err_stack;
1498:
1499: x_err_stack := x_err_stack || ' ->Before insert into Pa_Ei_Denorm_AR' ;
1500:
1501: LOOP
1502: if p_archive_flag = 'Y' then
1503: -- If archive option is selected then the records are

Line 1511: insert into Pa_Ei_Denorm_AR

1507: -- in the commit size.
1508:
1509: l_commit_size := p_commit_size / 2 ;
1510:
1511: insert into Pa_Ei_Denorm_AR
1512: (
1513: Expenditure_Id,
1514: Denorm_Id,
1515: Person_Id,

Line 1942: from pa_ei_denorm_ar eid2

1938:
1939: delete from pa_ei_denorm eid
1940: where (eid.denorm_id, eid.expenditure_id) in
1941: ( select eid2.denorm_id, eid.expenditure_id
1942: from pa_ei_denorm_ar eid2
1943: where eid2.purge_project_id = p_project_id ) ;
1944:
1945: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1946: end if;