APPS.AMW_PROJECT_EVENT_PVT dependencies on AMW_AUDIT_PROJECTS

Line 899: from AMW_AUDIT_PROJECTS

895: IS
896:
897: CURSOR c_engagements IS
898: Select audit_project_id
899: from AMW_AUDIT_PROJECTS
900: where AUDIT_PROJECT_STATUS = 'ACTI';
901:
902: CURSOR c_scope_org(l_audit_project_id NUMBER) IS
903: SELECT organization_id

Line 1008: UPDATE AMW_AUDIT_PROJECTS

1004:
1005: IF l_audit_project_id IS NOT NULL THEN
1006:
1007: /* Update the signOffStatus. */
1008: UPDATE AMW_AUDIT_PROJECTS
1009: SET sign_off_status = l_sign_off_status
1010: WHERE AUDIT_PROJECT_ID = l_audit_project_id;
1011:
1012: /* update the Engagement status */

Line 1014: UPDATE AMW_AUDIT_PROJECTS

1010: WHERE AUDIT_PROJECT_ID = l_audit_project_id;
1011:
1012: /* update the Engagement status */
1013: IF l_sign_off_status = 'APPROVED' THEN
1014: UPDATE AMW_AUDIT_PROJECTS
1015: SET audit_project_status = 'SIGN'
1016: WHERE AUDIT_PROJECT_ID = l_audit_project_id
1017: AND AUDIT_PROJECT_STATUS = 'ACTI';
1018: END IF;

Line 1077: UPDATE AMW_AUDIT_PROJECTS

1073:
1074: IF l_audit_project_id IS NOT NULL THEN
1075:
1076: /* Update the signOffStatus. */
1077: UPDATE AMW_AUDIT_PROJECTS
1078: SET sign_off_status = l_sign_off_status
1079: WHERE AUDIT_PROJECT_ID = l_audit_project_id;
1080:
1081: /* update the Engagement status */

Line 1083: UPDATE AMW_AUDIT_PROJECTS

1079: WHERE AUDIT_PROJECT_ID = l_audit_project_id;
1080:
1081: /* update the Engagement status */
1082: IF l_sign_off_status = 'APPROVED' THEN
1083: UPDATE AMW_AUDIT_PROJECTS
1084: SET audit_project_status = 'SIGN'
1085: WHERE AUDIT_PROJECT_ID = l_audit_project_id
1086: AND AUDIT_PROJECT_STATUS = 'ACTI';
1087: END IF;