APPS.PA_PURGE_COSTING dependencies on PA_EXP_HISTORY_AR

Line 2057: insert into PA_EXP_HISTORY_AR

2053: -- in the commit size.
2054:
2055: l_commit_size := p_commit_size / 2 ;
2056: if p_txn_to_date is NOT NULL then
2057: insert into PA_EXP_HISTORY_AR
2058: (
2059: Audit_Type_Code,
2060: Late_Entry_Code,
2061: Reason_Comment,

Line 2139: insert into PA_EXP_HISTORY_AR

2135: where xh.project_id = p_project_id
2136: and xh.expenditure_item_date <= p_txn_to_date
2137: and rownum < l_commit_size ;
2138: else
2139: insert into PA_EXP_HISTORY_AR
2140: (
2141: Audit_Type_Code,
2142: Late_Entry_Code,
2143: Reason_Comment,

Line 2231: from PA_EXP_HISTORY_AR xhar

2227: -- table and
2228: delete from pa_expenditure_history xh
2229: where (xh.expenditure_id, xh.denorm_id ) in
2230: ( select xhar.expenditure_id, xhar.denorm_id
2231: from PA_EXP_HISTORY_AR xhar
2232: where xhar.purge_project_id = p_project_id
2233: ) ;
2234:
2235: l_NoOfRecordsDel := SQL%ROWCOUNT ;