eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_PROCESS_EVAL_SUM

Line 241: SELECT COUNT(1) INTO L_COUNT2 FROM AMW_FIN_PROCESS_EVAL_SUM

237: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
238:
239: /** even if there is no process attached to an account. if the account belongs to the financial
240: ** certification, we should add it to the amw_fin_cert_scope table
241: SELECT COUNT(1) INTO L_COUNT2 FROM AMW_FIN_PROCESS_EVAL_SUM
242: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
243:
244:
245: IF (L_COUNT2 = 0 OR L_COUNT2 IS NULL) THEN

Line 578: AMW_FIN_PROCESS_EVAL_SUM eval,

574: risks.DELETION_APPROVAL_DATE,
575: risk.RISK_REV_ID
576: FROM
577: AMW_RISK_ASSOCIATIONS risks,
578: AMW_FIN_PROCESS_EVAL_SUM eval,
579: AMW_RISKS_B risk
580: WHERE
581: eval.fin_certification_id = p_certification_id
582: and risk.risk_id = risks.risk_id

Line 602: AMW_FIN_PROCESS_EVAL_SUM eval,

598: risks.DELETION_APPROVAL_DATE,
599: risk.RISK_REV_ID
600: FROM
601: AMW_RISK_ASSOCIATIONS risks,
602: AMW_FIN_PROCESS_EVAL_SUM eval,
603: AMW_RISKS_B risk
604: WHERE
605: eval.fin_certification_id = p_certification_id
606: and risk.risk_id = risks.risk_id