DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_ITEM_ACC_CTRL

Line 1402: amw_fin_item_acc_ctrl fin

1398: select distinct fin.control_id, fin.organization_id
1399: FROM
1400: amw_opinion_m_v aov,
1401: amw_opinions_log aol,
1402: amw_fin_item_acc_ctrl fin
1403: WHERE aov.OPINION_TYPE_CODE = ''EVALUATION''
1404: and aov.object_name = ''AMW_ORG_CONTROL''
1405: and aov.opinion_component_code = ''OVERALL''
1406: and aol.opinion_log_id = fin.OPINION_LOG_ID

Line 1604: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_CTRL

1600:
1601: -- Initialize API return status to SUCCESS
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1603:
1604: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_CTRL
1605: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1606:
1607: IF (L_COUNT = 0 OR L_COUNT IS NULL) THEN
1608:

Line 1609: insert into amw_fin_item_acc_ctrl

1605: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1606:
1607: IF (L_COUNT = 0 OR L_COUNT IS NULL) THEN
1608:
1609: insert into amw_fin_item_acc_ctrl
1610: (
1611: OBJECT_TYPE,
1612: FIN_CERTIFICATION_ID,
1613: STATEMENT_GROUP_ID ,