APPS.AMW_FINSTMT_FINDING_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

Select distinct CERTIFICATION_ID
from AMW_CERTIFICATION_VL
where object_type = 'FIN_STMT' and
CERTIFICATION_STATUS in ('ACTIVE','DRAFT');

Line: 65

 update amw_fin_process_eval_sum set
    LAST_UPDATE_DATE = sysdate,
    last_updated_by = fnd_global.user_id,
    last_update_login = fnd_global.conc_login_id,
    OPEN_FINDINGS = amw_findings_pkg.calculate_open_findings('AMW_PROJ_FINDING', 'PROJ_ORG_PROC', process_id, 'PROJ_ORG', organization_id, null, null, null, null, null, null)
    where fin_certification_id = p_certification_id;

Line: 72

 update amw_fin_org_eval_sum set
    LAST_UPDATE_DATE = sysdate,
    last_updated_by = fnd_global.user_id,
    last_update_login = fnd_global.conc_login_id,
    OPEN_FINDINGS = amw_findings_pkg.calculate_open_findings ('AMW_PROJ_FINDING', 'PROJ_ORG', organization_id, null, null,null, null,null, null, null, null )
    where fin_certification_id = p_certification_id;