APPS.EAM_SAFETY_ASSOCIATION_PVT dependencies on EAM_WORK_PERMITS

Line 78: FROM EAM_WORK_PERMITS

74: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking permit existence'); end if;
75:
76: SELECT COUNT(*)
77: INTO l_count
78: FROM EAM_WORK_PERMITS
79: WHERE PERMIT_ID = l_safety_assoc_rec.SOURCE_ID
80: AND organization_id = l_safety_assoc_rec.organization_id;
81:
82: IF (l_count < 1)

Line 187: FROM EAM_WORK_PERMITS WP

183: WHEN G_SAFETY_DUPLICATE_ASSO_ERROR THEN
184:
185: l_token_tbl(1).token_name := 'SOURCE';
186: SELECT WP.PERMIT_NAME into l_token_tbl(1).token_value
187: FROM EAM_WORK_PERMITS WP
188: WHERE WP.PERMIT_ID = l_safety_assoc_rec.SOURCE_ID
189: AND WP.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
190:
191: l_token_tbl(2).token_name := 'TARGET';

Line 470: FROM EAM_WORK_PERMITS

466: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking permit existence'); end if;
467:
468: SELECT COUNT(*)
469: INTO l_count
470: FROM EAM_WORK_PERMITS
471: WHERE permit_id = l_safety_assoc_rec.source_id
472: AND organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
473:
474:

Line 592: FROM EAM_WORK_PERMITS WP

588: WHEN G_SAFETY_DUPLICATE_ASSO_ERROR THEN
589:
590: l_token_tbl(1).token_name := 'SOURCE';
591: SELECT WP.PERMIT_NAME into l_token_tbl(1).token_value
592: FROM EAM_WORK_PERMITS WP
593: WHERE WP.PERMIT_ID = l_safety_assoc_rec.SOURCE_ID
594: AND WP.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
595:
596: