APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_ITEM_ACC_RISK

Line 1319: amw_fin_item_acc_risk fin

1315: l_stmt := 'select count(1) from (
1316: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
1317: FROM
1318: AMW_OPINION_M_V aov,
1319: amw_fin_item_acc_risk fin
1320: WHERE
1321: aov.OPINION_TYPE_CODE = ''EVALUATION''
1322: and aov.object_name = ''AMW_ORG_PROCESS_RISK''
1323: and aov.opinion_component_code = ''OVERALL''

Line 1336: amw_fin_item_acc_risk fin

1332: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
1333: FROM
1334: amw_opinion_m_v aov,
1335: amw_opinions_log aol,
1336: amw_fin_item_acc_risk fin
1337: WHERE
1338: aov.OPINION_TYPE_CODE = ''EVALUATION''
1339: and aov.object_name = ''AMW_ORG_PROCESS_RISK''
1340: and aov.opinion_component_code = ''OVERALL''

Line 1479: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_RISK

1475:
1476: -- Initialize API return status to SUCCESS
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_RISK
1480: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1481:
1482: IF (L_COUNT = 0 OR L_COUNT IS NULL) THEN
1483:

Line 1484: insert into amw_fin_item_acc_risk(

1480: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1481:
1482: IF (L_COUNT = 0 OR L_COUNT IS NULL) THEN
1483:
1484: insert into amw_fin_item_acc_risk(
1485: OBJECT_TYPE,
1486: FIN_CERTIFICATION_ID,
1487: STATEMENT_GROUP_ID,
1488: FINANCIAL_STATEMENT_ID,